Re: pl/pgsql or control structures outside of a function?

On Apr 3, 2009, at 5:03 PM, Peter Koczan wrote:

> Is there any way to use PL/pgSQL code outside of a function?

No.

>
>
> 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




John DeSoi, Ph.D.