cursor - Search results in mailing lists
Mailing lists >> pgsql-sql >> Thread
2024-03-25 16:26:43 | Re: Get error when calling function that returns a table (Tom Lane)
CURSOR FOR SELECT test_rr() ; needs to be more like DECLARE my_cur scroll CURSOR
Mailing lists >> pgsql-sql >> Thread >> Search in thread (4)
2024-03-22 16:50:04 | Cursor with hold for select takes too long (Bindra Bambharoliya)
cursor with hold for select. If I execute select quaery without cursor it takes 13 seconds
Mailing lists >> pgsql-sql >> Thread
2024-03-13 04:38:09 | Can portals interleave with other portals (Evgeny Smirnov)
cursors databaseClient.sql( "DECLARE fetch_test1 SCROLL CURSOR FOR SELECT * FROM users_Fetch;" + "DECLARE fetch
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2024-01-09 08:23:49 | Problem with refcursor (Maximilian Tyrtania)
cursors. I’ve got these 2 functions, this inner one: CREATE or replace FUNCTION f_client
Mailing lists >> pgsql-sql >> Thread >> Search in thread (6)
2021-12-10 15:40:41 | Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL (James Kitambara)
cursor data. Sorry I forget to share the procedure on my first email: Here is a procedure
Mailing lists >> pgsql-sql >> Thread
2021-06-15 13:33:28 | Re: function INPUT as whole table (Tom Lane)
cursor and passing the cursor name to the function, which could fetch from it. See the examples
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2021-05-31 14:37:57 | Check ref cursor (Yambu)
Hello How do i check if ref cursor is pointing to empty data? regards
Mailing lists >> pgsql-sql >> Thread
2020-12-02 15:25:37 | parallel safe on user defined functions (Voillequin, Jean-Marc)
cursors, prepared statements, or miscellaneous backend-local state which the system cannot synchronize across workers
Mailing lists >> pgsql-sql >> Thread >> Search in thread (3)
2020-06-26 23:59:54 | Re: Optimizer Hint, to ignore limit and offset in optimizer plan (Bruce Momjian)
cursors: WITH HOLD specifies that the cursor can continue to be used after the transaction
Mailing lists >> pgsql-sql >> Thread
2020-05-11 21:17:27 | Exporting modifications to a table as XML/JSON ()
Cursor CURSOR LOCAL FAST_FORWARD FOR SELECT distinct RecId,Code FROM #TempTbl Open Audit_Cursor
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2020-04-23 13:37:24 | Re: [postgis-users] How to sql scripts in a file? (Giuseppe Broccolo)
cursors (available from version 2.5): sqlF = r'{}\{}'.format(sFldr_sql,sSQLFile) with psycopg2.connect(...) as conn
Mailing lists >> pgsql-sql >> Thread >> Search in thread (6)
2019-08-30 13:40:24 | Re: libpq: How are result sets fetched behind the scene? (Sebastien FLAESCH)
cursor using fetch forward to get rows in blocks), if you fetch all rows sequentially
Mailing lists >> pgsql-sql >> Thread
2019-08-03 01:03:52 | [ECPG] - Help on Dynamic Query using SQLDA with Cursors (Rajesh Parameswaran)
CURSOR for INSERT SQL. I'm getting the following errors. Please let me know, if you need
Mailing lists >> pgsql-sql >> Thread
2019-07-22 20:58:41 | Interesting security context issue (Erik Brandsberg)
cursor', 'select CURRENT_USER'); fetch all in "cursor"; commit; In this case, the result will
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2018-11-28 18:37:25 | RE: error code 8 (Olivier Leprêtre)
cursor_tuple_fraction = 0.1 # range 0.0-1.0 #from_collapse_limit = 8 #join_collapse_limit = 8 # 1 disables