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	April 4, 2009 04:28:50
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?
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:

From: Peter Koczan
Date: 03 April 2009, 21:03:30
Subject: pl/pgsql or control structures outside of a function?

From: "Greg Sabino Mullane"
Date: 06 April 2009, 02:22:17
Subject: Re: How would I get rid of trailing blank line?

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

Previous

Next