Re: BUG #2096: bug in a SPI sample document - Mailing list pgsql-bugs

From NAKANO Yoshihisa
Subject Re: BUG #2096: bug in a SPI sample document
Date
Msg-id 4407C752.1010902@jp.fujitsu.com
Whole thread Raw
In response to Re: BUG #2096: bug in a SPI sample document  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Bruce Momjian wrote:
> This documentation bug has been fixed.  We currently have:
>
>     => SELECT * FROM a;
>      x
>     ---
>      1                  -- no rows in a (0) + 1
>     (1 row)
>
>     => INSERT INTO a VALUES (execq('SELECT * FROM a', 0) + 1);
>     INFO:  EXECQ:  1
>     INSERT 0 1
>
> Is the "INSERT 0 1" right?  I see an oid in your example, but that might
> be because we no longer user oids by default.

Yes.  IIRC, Tom had already pointed out that and fixed.

http://archives.postgresql.org/pgsql-bugs/2005-12/msg00071.php

Regards,
Yoshihisa Nakano

pgsql-bugs by date:

Previous
From: "Jim Fitzgerald"
Date:
Subject: Re: BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger.
Next
From: "Raymond Henick"
Date:
Subject: General PostgresSQL Query