On Fri, Apr 3, 2009 at 11:28 PM, John DeSoi <de...@pgedit.com> wrote: >> Is there any way to use PL/pgSQL code outside of a function? > > No.
I kinda figured, but it doesn't hurt to ask. >> The reason I'm asking is that I'm porting some code from >> sybase/isql/SQR, and it allows some control code structures to be used >> in an sql script. For instance, > > CASE might work for you. > > http://www.postgresql.org/docs/8.3/interactive/functions-conditional.html Thanks for the suggestion. I think that for what I'm trying to do, adding a bunch of case statements would very quickly become unmaintainable. Wrapper scripts are probably the way to go for me. Thanks again, Peter -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql