Karsten Hilbert <[EMAIL PROTECTED]> writes:
> The docs do hint at how to do it properly:
> "PERFORM create_mv(''cs_session_page_requests_mv'', my_query);"
> but this might be helpful to be pointed out explicitely:
> "PERFORM create_mv(''cs_session_page_requests_mv'', my_query);
> Note that the PE
On Thu, Sep 21, 2006 at 02:50:08PM +0200, Marcin Mank wrote:
> With:
>
> perform cmd;
> raise notice ''found (perform): %'', found;
>
> You effectively do:
> select 'select 1 from test where fk_item=1324314' ;
>
>
> Try:
>
> perform 1 from test where fk_item=1324314
Marcin, you saved my da
> gives the result below. It seems inconsistent to me with
> regard to the FOUND variable. I would expect FOUND to always
> be false regardless of whether I use EXECUTE or PERFORM. I
> certainly do not expect it to be true for the third EXECUTE
> even assuming that PERFORM may have a bug. What is i
On Thu, Sep 21, 2006 at 01:32:02PM +0200, Martijn van Oosterhout wrote:
> I beleive that since PERFORM doesn't return anything, it sets the FOUND
> variable to at least indicate whether it did something.
The weird thing is that in the example it sets FOUND to true
even if it did NOT do anything.
On Thu, Sep 21, 2006 at 01:32:02PM +0200, Martijn van Oosterhout wrote:
> > So, what about the PERFORM ? Why does it set FOUND to true?
>
> I beleive that since PERFORM doesn't return anything, it sets the FOUND
> variable to at least indicate whether it did something.
The docs say that it sets
On Thu, Sep 21, 2006 at 01:15:46PM +0200, Karsten Hilbert wrote:
> Assuming EXECUTE does not touch FOUND at all the EXECUTE
> part behaves consistently (namely default FOUND=FALSE at the
> beginning and later whatever it was after the PERFORM).
>
> So, what about the PERFORM ? Why does it set FOU
On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:
> gives the result below. It seems inconsistent to me with
> regard to the FOUND variable. I would expect FOUND to always
> be false regardless of whether I use EXECUTE or PERFORM. I
> certainly do not expect it to be true for the th
On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:
> I am utterly confused now. Running the attached script on Debian:
>
> postgresql:
> Installiert:7.5.21
> Mögliche Pakete:7.5.21
> Versions-Tabelle:
> *** 7.5.21 0
> 990 ftp://ftp.gwdg.de testing/main Packages
>
Hi,
I am utterly confused now. Running the attached script on Debian:
postgresql:
Installiert:7.5.21
Mögliche Pakete:7.5.21
Versions-Tabelle:
*** 7.5.21 0
990 ftp://ftp.gwdg.de testing/main Packages
100 /var/lib/dpkg/status
7.4.7-6sarge3 0
500 ftp://ftp.gwdg.de
