2010/9/3 Merlin Moncure :
> On Fri, Sep 3, 2010 at 3:47 PM, John Adams wrote:
>>> psql has some client side manged variables, and you can of course use
>>> pl/pgsql.
>> Do you mean I should use a pl/pgsql stored procedure or do I have to somehow
>> mark the sql as pl/pgsql? How?
>> Because in sql
On Fri, Sep 3, 2010 at 3:47 PM, John Adams wrote:
>> psql has some client side manged variables, and you can of course use
>> pl/pgsql.
> Do you mean I should use a pl/pgsql stored procedure or do I have to somehow
> mark the sql as pl/pgsql? How?
> Because in sql server it is all the same i.e. pl
On Fri, Sep 3, 2010 at 2:45 PM, John Adams 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
clien
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;
