Re: PERFORM statement

From: Tony Theodore <tony(dot)theodore(at)gmail(dot)com>
To: Mike Christensen <mike(at)kitchenpc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PERFORM statement
Date: 2013-07-09 04:38:55
Message-ID: 86106130-5E99-489F-840C-FB889C553DC1@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 09/07/2013, at 2:20 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
>
> PERFORM MyInsert(1,101,'2013-04-04','2013-04-04',2,'f' );
>
> I get the error:
>
> ERROR: syntax error at or near "PERFORM"
> SQL state: 42601
> Character: 1
>
> Is the FAQ out of date or was this feature removed? I'm using 9.2.1. Thanks!

I believe PERFORM is a PL/pgSQL construct, not an SQL one. You'd need to execute it inside a function.

Cheers,

Tony

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2013-07-09 04:45:59 Re: PERFORM statement
Previous Message Mike Christensen 2013-07-09 04:20:13 PERFORM statement