Re: Anybody see the post?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Anybody see the post?
Date: 2003-02-18 15:18:50
Message-ID: 23555.1045581530@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Weiping He <laser(at)zhengmai(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-02-18 15:19:43 Re: Handling users
Previous Message Mark Cave-Ayland 2003-02-18 15:14:06 7.3.1 takes long time to vacuum table?