Search Postgresql Archives

Re: = or := ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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

Some languages, such as perl, use = for assignment and == for logical comparison.

x = 1
is a boolean result

x := 1
gives x the value of 1

Quick example:

	x := 2; -- gives x the value of 2

	IF (x = 1) THEN -- x = 1 is false
		x := 3;  -- skipped
	END IF;
	RETURN X; -- returns 2

Again:
	x := 1; -- gives x the value of 1

	IF (x = 1) THEN -- x = 1 is true
		x := 3;  -- perform assignment
	END IF;
	RETURN x; -- returns 3

Hope this helps.

Michael Glaesemann
grzm myrealbox com


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux