Re: syntax error at or near "PERFORM"

From: Dale <harris_da(at)yahoo(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: syntax error at or near "PERFORM"
Date: 2008-08-15 04:32:56
Message-ID: 516a604f-2e64-4e60-8d4a-1cdb52dadfab@j33g2000pri.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Aug 15, 2:14 pm, Dale <harris(dot)(dot)(dot)(at)yahoo(dot)com(dot)au> wrote:
> Hi,
>
> When ever I try and call the PERFORM statement I get:
> ERROR:  syntax error at or near "PERFORM"
> even when I try executing something basic:  PERFORM (2 + 3);
>
> Any ideas please?
>
> Dale.

I found my problem. Unfortunately PERFORM can only be used within a
"LANGUAGE plpgsql" script.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-08-15 06:47:33 Re: Incorrect results with NOT IN
Previous Message Dale 2008-08-15 04:14:43 syntax error at or near "PERFORM"