Re: How can I use parameters in plain sql - Mailing list pgsql-general

On Fri, Sep 3, 2010 at 2:45 PM, John Adams <john_adams_mail@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 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