dbTalk Databases Forums  

Re: [BUGS] BUG #2849: Erroronous UPDATE syntax in documentation

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] BUG #2849: Erroronous UPDATE syntax in documentation in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gurjeet Singh
 
Posts: n/a

Default Re: [BUGS] BUG #2849: Erroronous UPDATE syntax in documentation - 12-21-2006 , 06:09 AM






------=_Part_61189_24005549.1166702887744
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 12/21/06, Gurjeet Singh <singh.gurjeet (AT) gmail (DOT) com> wrote:
Quote:

The following bug has been logged online:

Bug reference: 2849
Logged by: Gurjeet Singh
Email address: singh.gurjeet (AT) gmail (DOT) com
PostgreSQL version: 8.2.0
Operating system: Windows
Description: Erroronous UPDATE syntax in documentation

*** Erroneous ***



--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

------=_Part_61189_24005549.1166702887744
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 12/21/06, <b class="gmail_sendername">Gurjeet Singh</b> &lt;<a href="mailto:singh.gurjeet (AT) gmail (DOT) com">singh.gurjeet (AT) gmail (DOT) com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>The following bug has been logged online:<br><br>Bug reference:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2849 <br>Logged by:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;Gurjeet Singh<br>Email address:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="mailto:singh.gurjeet (AT) gmail (DOT) com">singh.gurjeet (AT) gmail (DOT) com</a><br>PostgreSQL version:
8.2.0<br>Operating system:&nbsp;&nbsp; Windows<br>Description:&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp;Erroronous UPDATE syntax&nbsp;&nbsp;in documentation</blockquote><div><br>*** Erroneous&nbsp; ***<br></div><br></div><br clear="all"><br>-- <br>gurjeet[.singh]@EnterpriseDB.com
<br>singh.gurjeet@{ gmail | hotmail | yahoo }.com

------=_Part_61189_24005549.1166702887744--


Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] BUG #2849: Erroronous UPDATE syntax in documentation - 12-27-2006 , 10:09 AM






"Gurjeet Singh" <singh.gurjeet (AT) gmail (DOT) com> writes:
Quote:
http://www.postgresql.org/docs/8.2/i....html#AEN38727
illustrates the examples using wrong syntax of UPDATE command. The FROM
clause is missing; if the FROM clause and the appropriate table is added to
the query, it works fine.
Well, it used to be right ;-) ... but yeah, now that add_missing_from
defaults to off we should adjust the examples. Done, thanks for the
report.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.