| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | wove5(at)outlook(dot)com |
| Subject: | 34.3.2. Using Cursors |
| Date: | 2024-12-02 23:55:30 |
| Message-ID: | 173318373001.2556777.2216753691283457026@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/ecpg-commands.html
Description:
I think there is a missing colon in the example code "Select using
cursors":
EXEC SQL DECLARE foo_bar CURSOR FOR
SELECT number, ascii FROM foo
ORDER BY ascii;
EXEC SQL OPEN foo_bar;
EXEC SQL FETCH foo_bar INTO :FooBar, DooDad;
... ^
EXEC SQL CLOSE foo_bar;
EXEC SQL COMMIT;
Should DooDad be prepended with a colon?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Smith | 2024-12-03 01:45:42 | Re: pg_createsubscriber: publication-name and subscription-name options do not exist |
| Previous Message | Shubham Khanna | 2024-12-02 17:32:09 | Re: pg_createsubscriber: publication-name and subscription-name options do not exist |