Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/pgsql or control structures outside of a function? - Mailing list pgsql-sql

From John DeSoi
Subject Re: pl/pgsql or control structures outside of a function?
Date
Msg-id 29505E7D-05C7-4F8A-91AD-C5596FA51987@pgedit.com
Whole thread Raw
In response to pl/pgsql or control structures outside of a function?  (Peter Koczan <pjkoczan@gmail.com>)
Responses Re: pl/pgsql or control structures outside of a function?  (Peter Koczan <pjkoczan@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Peter Koczan
Date:
Subject: pl/pgsql or control structures outside of a function?
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: How would I get rid of trailing blank line?