Re: BUG #2096: bug in a SPI sample document

From: NAKANO Yoshihisa <nakano(dot)yosihisa(at)jp(dot)fujitsu(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2096: bug in a SPI sample document
Date: 2006-03-03 04:34:26
Message-ID: 4407C752.1010902@jp.fujitsu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Qingqing Zhou 2006-03-03 06:35:25 prepare-alter-exec issue
Previous Message Bruce Momjian 2006-03-03 04:17:33 Re: BUG #2096: bug in a SPI sample document