Re: Strange behavior of "=" as assignment operator

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Johnston <polobo(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange behavior of "=" as assignment operator
Date: 2013-06-01 21:27:28
Message-ID: 1370122048.6266.YahooMailNeo@web162902.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Daw 2013-06-02 20:03:48 Differences in Unicode handling on Mac vs Linux?
Previous Message Adrian Klaver 2013-06-01 17:41:24 Re: Insert with query