cursor - Search results in mailing lists
Mailing lists >> pgsql-docs >> Thread
2024-12-03 02:55:30 | 34.3.2. Using Cursors (PG Doc comments form)
cursors": EXEC SQL DECLARE foo_bar CURSOR FOR SELECT number, ascii FROM foo ORDER BY ascii
Mailing lists >> pgsql-docs >> Thread >> Search in thread (2)
2024-09-25 14:24:25 | Re: Count parameter for cursor_to_xml (Daniel Gustafsson)
cursor_to_xml fetches the indicated number of rows from the cursor specified by the parameter
Mailing lists >> pgsql-docs >> Thread
2024-09-13 18:28:58 | Re: Undocumented optionality of handler_statements (Philipp Salvisberg)
through Arrays - 43.7.4. Looping through a Cursor's Result The PL/pgSQL implementation allows empty branches.
Mailing lists >> pgsql-docs >> Thread
2024-07-22 16:24:35 | Re: Undocumented count in FORWARD/BACKWARD direction of MOVE statement (Tom Lane)
cursor without retrieving any data. MOVE works like the FETCH command, except it only repositions
Mailing lists >> pgsql-docs >> Thread
2024-01-25 04:46:56 | It would be nice to clarify is there any point in select queries pipelining (PG Doc comments form)
cursor(portal) multiplexing so its impossible to fetch data for two selects simultaneously but should
Mailing lists >> pgsql-docs >> Thread
2023-10-17 11:14:41 | Re: No explanation of other options (jian he)
cursor for select * from generate_series(1,4) i where i <> all (values (2),(3)); move
Mailing lists >> pgsql-docs >> Thread >> Search in thread (4)
2023-06-06 19:48:42 | Re: pass open cursor via USING in execute staement (Kirk Wolak)
cursor name by simply doing: RAISE NOTICE 'Cursor Name: %', cCursor; So you can copy it to a variable
Mailing lists >> pgsql-docs >> Thread
2022-10-27 19:45:09 | Cursor Names are "Session Global while Opened"? (should be mentioned in the docs) (PG Doc comments form)
cursor: cur_this in a procedure. Then while that cursor is OPEN, I call ANOTHER
Mailing lists >> pgsql-docs >> Thread >> Search in thread (6)
2022-10-24 03:24:16 | Re: jsonlog cursor_position type is wrong. (Tatsuo Ishii)
postgres_log FROM '/full/path/to/logfile.csv' WITH csv; cursor_position - string + number Cursor index into query string
Mailing lists >> pgsql-docs >> Thread >> Search in thread (2)
2022-04-12 14:48:03 | Re: Missing example for SAVEPOINT using the same savepoint name (Sebastien Flaesch)
cursor can no longer be used. + + + If multiple savepoints have the same name, only the one that
Mailing lists >> pgsql-docs >> Thread
2022-03-21 10:09:55 | SQL "RETURNING * | output_expression [ [ AS ]" is wrong (PG Doc comments form)
cursor_name ] [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ] BUT it does not work, it does
Mailing lists >> pgsql-docs >> Thread >> Search in thread (3)
2021-10-07 20:24:16 | Re: small patch (Tom Lane)
cursor_name which in fact is legal. I think however that we could make it read
Mailing lists >> pgsql-docs >> Thread >> Search in thread (2)
2021-07-03 11:54:11 | ECPG cursor examples should include EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while loop (PG Doc comments form)
CURSOR examples fail. For example, this example under 36.4.4.3.2. Structures fails: EXEC SQL BEGIN DECLARE
Mailing lists >> pgsql-docs >> Thread
2021-05-04 23:18:48 | Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error (Tom Lane)
cursor_to_xml fetches the indicated number of @@ -17316,49 +17317,9 @@ SELECT setval('myseq
Mailing lists >> pgsql-docs >> Thread
2020-05-12 05:10:06 | Re: Remaining PDF layout issues (Tom Lane)
cursor which last read data from the - buffer in question. - - - - - Activity : The server process is idle