On Thu, 2008-02-28 at 20:11 +0100, BERTRAND Joël wrote: > Tom Lane wrote: > > =?ISO-8859-1?Q?BERTRAND_Jo=EBl?= <joel.bertrand@xxxxxxxxxxx> writes: > >> What is the difference between "=" and ":=" ? > > > > None; plpgsql accepts either for assignment. > > Thank you for your answer. I suggest to add a note in documentation ;-) I think that it is undocumented on purpose. "=" in SQL is generally for testing equality, and having one operator mean two completely different things can be confusing. Therefore, ":=" is encouraged. Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
