Re: syntax error at or near "PERFORM" - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: syntax error at or near "PERFORM"
Date
Msg-id 48A5E9C0.9070505@iol.ie
Whole thread Raw
In response to Re: syntax error at or near "PERFORM"  (Dale <harris_da@yahoo.com.au>)
List pgsql-general
On 15/08/2008 05:32, Dale wrote:
> On Aug 15, 2:14 pm, Dale <harris...@yahoo.com.au> wrote:
<snip>
>> even when I try executing something basic:  PERFORM (2 + 3);
<snip>
> I found my problem.  Unfortunately PERFORM can only be used within a
> "LANGUAGE plpgsql" script.

Yes, that's it - outside a function, you just do:

   select (2 + 3);

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [Q] DNS(bind) ER model
Next
From: Raymond O'Donnell
Date:
Subject: Re: plpgsql functions