Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group