On Fri, Sep 3, 2010 at 2:45 PM, John Adams <john_adams_m...@yahoo.com> 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 i...@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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general