public inbox for [email protected]help / color / mirror / Atom feed
"FETCH returns data as if it were a SELECT result" 3+ messages / 2 participants [nested] [flat]
* "FETCH returns data as if it were a SELECT result" @ 2005-08-02 15:32 Roman Neuhauser <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Roman Neuhauser @ 2005-08-02 15:32 UTC (permalink / raw) To: pgsql-docs "The variant of FETCH described here returns the data as if it were a SELECT result rather than placing it in host variables." http://www.postgresql.org/docs/current/static/sql-fetch.html That doesn't seem to be the case. Try the following script: CREATE TABLE t1 (t1i INT, t1c CHAR(1)); CREATE TABLE t2 (t2i INT, t2c CHAR(1)); INSERT INTO t1 VALUES (1, 'a'); INSERT INTO t1 VALUES (2, 'b'); INSERT INTO t1 VALUES (3, 'c'); BEGIN; INSERT INTO t2 (SELECT * FROM t1); SELECT * FROM t2; ROLLBACK; BEGIN; DECLARE c1 CURSOR FOR SELECT * FROM t1; INSERT INTO t2 (FETCH ALL FROM c1); ROLLBACK; The output I get: CREATE TABLE CREATE TABLE INSERT 19110 1 INSERT 19111 1 INSERT 19112 1 BEGIN INSERT 0 3 t2i | t2c -----+----- 1 | a 2 | b 3 | c (3 rows) ROLLBACK BEGIN DECLARE CURSOR psql:tmp/fetch-is-unlike-select.sql:15: ERROR: syntax error at or near "ALL" at character 23 psql:tmp/fetch-is-unlike-select.sql:15: LINE 1: INSERT INTO t2 (FETCH ALL FROM c1); psql:tmp/fetch-is-unlike-select.sql:15: ^ ROLLBACK This is on PostgreSQL 8.0.3 on i386-portbld-freebsd4.11, compiled by GCC 2.95.4 -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "FETCH returns data as if it were a SELECT result" @ 2005-08-02 17:09 Tom Lane <[email protected]> parent: Roman Neuhauser <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2005-08-02 17:09 UTC (permalink / raw) To: Roman Neuhauser <[email protected]>; +Cc: pgsql-docs Roman Neuhauser <[email protected]> writes: > "The variant of FETCH described here returns the data as if it were a > SELECT result rather than placing it in host variables." > That doesn't seem to be the case. It means it returns data *to the client* in the same way a SELECT does. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "FETCH returns data as if it were a SELECT result" @ 2005-08-02 19:04 Roman Neuhauser <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Roman Neuhauser @ 2005-08-02 19:04 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: pgsql-docs # [email protected] / 2005-08-02 13:09:58 -0400: > Roman Neuhauser <[email protected]> writes: > > "The variant of FETCH described here returns the data as if it were a > > SELECT result rather than placing it in host variables." > > > That doesn't seem to be the case. > > It means it returns data *to the client* in the same way a SELECT does. Ok, and what does *that* mean? If you spend a few minutes on an explanation, I'll submit a patch to the documentation. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-08-02 19:04 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-08-02 15:32 "FETCH returns data as if it were a SELECT result" Roman Neuhauser <[email protected]> 2005-08-02 17:09 ` Tom Lane <[email protected]> 2005-08-02 19:04 ` Roman Neuhauser <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox