Re: Anybody see the post? - Mailing list pgsql-general

From Tom Lane
Subject Re: Anybody see the post?
Date
Msg-id 23555.1045581530@sss.pgh.pa.us
Whole thread Raw
In response to Anybody see the post?  (Weiping He <laser@zhengmai.com.cn>)
List pgsql-general
Weiping He <laser@zhengmai.com.cn> writes:
>      it seems PERFORM won't affect result status while doing
>      SELECT ... query, but EXECUTE do.

It works for me.

>          raise notice '' SQL: % '', qry;
> --      execute qry;
>          perform qry;

This should give you an error.  perform doesn't take a string
expression.  You want something more like

    perform t FROM test where ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: 7.3.1 takes long time to vacuum table?
Next
From: Richard Welty
Date:
Subject: Re: Handling users