BUG #2096: bug in a SPI sample document

From: "Yoshihisa Nakano" <nakano(dot)yosihisa(at)jp(dot)fujitsu(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2096: bug in a SPI sample document
Date: 2005-12-07 03:28:14
Message-ID: 20051207032814.2BDDEF0E45@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2096
Logged by: Yoshihisa Nakano
Email address: nakano(dot)yosihisa(at)jp(dot)fujitsu(dot)com
PostgreSQL version: 8.1.0
Operating system: RedHat Enterprise Linux ES 3.0
Description: bug in a SPI sample document
Details:

There is a difference between the result of the SPI
example in the doc and the actual result of that.

Doc 40.5 Examples
=> 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: 0
INSERT 167713 1

I tried this example, but INFO showed 1, not 0. I
think the value of INFO in doc is wrong, because the
value of row is 1 at this time.

This bug seems to exist also in 7.3.x, 7.4.x and 8.0.x.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-12-07 04:58:02 Re: BUG #2000: psql does not prompt for password
Previous Message Golubev, Nickolas USA 2005-12-06 19:28:42 Re: BUG #2095: make looping