Cursor names
| От | Nathaniel Trellice |
|---|---|
| Тема | Cursor names |
| Дата | |
| Msg-id | 976377.74220.qm@web25006.mail.ukl.yahoo.com обсуждение исходный текст |
| Ответы |
Re: Cursor names
|
| Список | pgsql-novice |
Hi all, I'm using a cursor to read query results a few rows at a time. The syntax I'm using to 'create' the cursor is: DECLARE <cursor name> BINARY CURSOR FOR SELECT [rest of query]; followed by calls to FETCH FORWARD <num rows> FROM <cursor name> and everything's working nicely. My DB has multiple clients each of which may have multiple connections open the the DB (the client app is threaded), allmaking cursored queries simultaneously. So my question is: what are the constraints on <cursor name>? Must each cursor name be unique amongst all declared cursorsfrom all clients, or just unique within a single connection from a single client, or something else? Nathaniel
В списке pgsql-novice по дате отправления: