Re: [GENERAL] using = in a function

2008-01-29 Thread Raymond O'Donnell
On 29/01/2008 02:41, Tom Lane wrote: Andy Colson <[EMAIL PROTECTED]> writes: Notice I just use = and not :=. [snip] Yeah, plpgsql actually allows both, but it's not documented. I really like := 'cos I've used Delphi/Pascal a lot over the years, so := falls nicely under the fingers. :-) Ra

Re: [GENERAL] using = in a function

2008-01-28 Thread Tom Lane
Andy Colson <[EMAIL PROTECTED]> writes: > An assignment of a value to a PL/pgSQL variable or row/record field is > written as: > variable := expression; > Notice I just use = and not :=. > My question is, is there a difference? It seems to work both ways, so > I'm a little confused. Yeah, plp

[GENERAL] using = in a function

2008-01-28 Thread Andy Colson
Hi all, I was reading the doc's on functions when I came across this: " An assignment of a value to a PL/pgSQL variable or row/record field is written as: variable := expression; " and I realized, I didn't do that! My assignments look like: tmp = extract(minute from result); if tmp > 30 th