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
Στις 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
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
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