Alex Peshkov escreveu:

> On Friday 14 December 2007 16:08, Adriano dos Santos Fernandes wrote:
>
>> select * from proc(set x = 1, y = 2);
>> execute statement 'select 1 from t where a = :a and b = :b' (set a =
>> 1, b = 2);
>>
>
> In that case () are not needed - just:
>
> select * from proc set x = 1, y = 2;

I prefer :-) to have lists inside parenthesis, as others PSQL constructions.

Another possibles syntaxes:
select * from proc with (x = 1, y = 2)
select * from proc set (x = 1, y = 2) -- set seems better outside
the parenthesis (but not very like UPDATE...SET)


Adriano