Re: = or := ? - Mailing list pgsql-general

From Tom Lane
Subject Re: = or := ?
Date
Msg-id 25180.1115646434@sss.pgh.pa.us
Whole thread Raw
In response to Re: = or := ?  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
Michael Glaesemann <grzm@myrealbox.com> writes:
> On May 9, 2005, at 18:00, Zlatko Matic wrote:
>> This is a newbie question: what is the difference between using = and
>> := in plpgsql function ?

> In pl/pgsql,

> := is assignment
> = is a logical comparison for equality

It looks like the code will in fact allow you to spell an assignment
statement either way ... but I recommend following Michael's advice
for clarity.

            regards, tom lane

pgsql-general by date:

Previous
From: "Sim Zacks"
Date:
Subject: Re: function call error
Next
From: Robert Treat
Date:
Subject: Re: Booleans - Why in Postgres and not in Oracle or Mysql?