using = in a function - Mailing list pgsql-general

From Andy Colson
Subject using = in a function
Date
Msg-id 479E54C3.2090201@squeakycode.net
Whole thread Raw
Responses Re: using = in a function
List pgsql-general
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 then
    tmp = 60 - tmp;
    offset = tmp || ' minutes';
    result = result + offset;
else
    offset = tmp || ' minutes';
    result = result - offset;
end if;


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.

Thanks,

-Andy

pgsql-general by date:

Previous
From: Jeremy Harris
Date:
Subject: enabling autovacuum
Next
From: John Gateley
Date:
Subject: Re: Table has duplicate keys, what did I do