Re: PERFORM statement

[Mike Christensen <mike@xxxxxxxxxxxxx>]

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@xxxxxxxxx> wrote:

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