Re: syntax error at or near "PERFORM"

On 15/08/2008 05:32, Dale wrote:
> On Aug 15, 2:14 pm, Dale <harris(dot)(dot)(dot)(at)yahoo(dot)com(dot)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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------