Re: How can I use parameters in plain sql

On Fri, Sep 3, 2010 at 3:47 PM, John Adams <john_adams_mail(at)yahoo(dot)com> 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. plain sql=tsql

pl/pgsql is only used in functions:

create function foo(i int) returns setof mytable as
$$
begin
return query select * from mytable where id = i;
end;
$$ language plpgsql;

then

plpgsql is reserved for fancy things that are tricky to do with plain
sql. it's got loops, robust error handling, etc.

http://www.postgresql.org/docs/8.4/static/plpgsql.html

merlin