Home > mailing lists

Re: PERFORM statement - Mailing list pgsql-general

From	Mike Christensen
Subject	Re: PERFORM statement
Date	July 9, 2013 07:46:03
Msg-id	CABs1bs15B=tQAPaUy5_K0ShuYc=g8PsW652xuMmy=C-_hxZoOw@mail.gmail.com Whole thread Raw
In response to	Re: PERFORM statement (Tony Theodore <tony.theodore@gmail.com>)
List	pgsql-general

Tree view

Ah ok that makes sense. The FAQ wasn't exactly clear about that.

On Mon, Jul 8, 2013 at 9:38 PM, Tony Theodore <tony.theodore@gmail.com> wrote:

On 09/07/2013, at 2:20 PM, Mike Christensen <mike@kitchenpc.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

pgsql-general by date:

From: Tony Theodore
Date: 09 July 2013, 07:43:57
Subject: Re: PERFORM statement

From: Darren Duncan
Date: 09 July 2013, 11:08:55
Subject: Re: Longest Common Subsequence in Postgres - Algorithm Challenge

Re: PERFORM statement - Mailing list pgsql-general

Previous

Next