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.
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 |