Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

using = in a function



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group