On Fri, Sep 3, 2010 at 2:45 PM, John Adams <john_adams_mail@xxxxxxxxx> wrote: > How can I use parameters in plain sql like sql server. > > FICTIONAL example that works for sql server: > declare @i int; > set @i = 1; > select * from mytable where id=@i; postgresql doesn't support variables in plain sql. psql has some client side manged variables, and you can of course use pl/pgsql. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
