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 SELECT INTO a v FROM foo Pavel > > http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPG > >SQL-STATEMENTS-ASSIGNMENT > > Sure, i missed the > "As explained above, the expression in such a statement is evaluated by means > of an SQL SELECT command sent to the main database engine. The expression > must yield a single value." > part. > Thanx. > > > > > Regards > > Pavel Stehule > > > > > -- > > > Achilleas Mantzios > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 6: explain analyze is your friend > > > > -- > Achilleas Mantzios > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
