Re: Strange behavior of "=" as assignment operator - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Strange behavior of "=" as assignment operator
Date
Msg-id 1370122048.6266.YahooMailNeo@web162902.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Strange behavior of "=" as assignment operator  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> The SQL standard uses "=" for assignment in other contexts,
> most notably UPDATE, but also the SQL/PSM standard uses it in
> <assignment statement> which is the exact same thing as in
> pl/pgsql.  So while purists might wish we only accepted :=, doing
> so would be inconsistent with SQL.
>
> I think we should just document it and move on.

+1

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Insert with query
Next
From: Matt Daw
Date:
Subject: Differences in Unicode handling on Mac vs Linux?