Re: [SQL] Calling functions from within pl/pgsql

2007-12-04 Thread Pavel Stehule
Hello a := exprx is internally translated : get result of SELECT exprx and store it to a so you can write select sin(10); then you can a := sin(10) but you can too use subselect like: SELECT (SELECT v FROM foo LIMIT 1) ~ you can write a := (SELECT v FROM foo LIMIT 1); that is equal to S

Re: [SQL] Calling functions from within pl/pgsql

2007-12-04 Thread Achilleas Mantzios
Στις Tuesday 04 December 2007 14:59:43 ο/η Pavel Stehule έγραψε: > On 04/12/2007, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: > > I noticed that in pl/pgsql simply > > result := funcname(func,args,...); > > just works. > > Should i rely on it or take it as a coincidence? :) > > You found assignme

Re: [SQL] Calling functions from within pl/pgsql

2007-12-04 Thread Pavel Stehule
On 04/12/2007, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: > I noticed that in pl/pgsql simply > result := funcname(func,args,...); > just works. > Should i rely on it or take it as a coincidence? :) You found assignment :). Sure, you can use it. http://www.postgresql.org/docs/8.2/interactive/pl

[SQL] Calling functions from within pl/pgsql

2007-12-04 Thread Achilleas Mantzios
I noticed that in pl/pgsql simply result := funcname(func,args,...); just works. Should i rely on it or take it as a coincidence? :) -- Achilleas Mantzios ---(end of broadcast)--- TIP 6: explain analyze is your friend