On Fri, Sep 3, 2010 at 3:47 PM, John Adams <john_adams_m...@yahoo.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
