| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Values list-of-targetlists patch for comments (was Re: |
| Date: | 2006-08-03 05:31:06 |
| Message-ID: | Pine.LNX.4.58.0608031523090.4590@linuxworld.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers pgsql-patches |
Docs and regression tests attached.
One slightly annoying thing is this:
---
regression=# declare foo cursor with hold for VALUES(1,2), (3, 4);
DECLARE CURSOR
regression=# declare foo2 cursor with hold for (VALUES(1,2), (3, 4)) as
foo(i, j);
ERROR: syntax error at or near "as"
LINE 1: ...e foo2 cursor with hold for (VALUES(1,2), (3, 4)) as foo(i, ...
---
Now, we can just rewrite the second query as:
---
declare foo2 cursor with hold for select * from (VALUES(1,2), (3, 4)) as
foo(i, j);
---
but it's not immediately obvious. Not worth busting up the grammar for it,
though. And, it's not spec.
Gavin
| Attachment | Content-Type | Size |
|---|---|---|
| values_doc_test.diff | text/plain | 16.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-03 12:48:57 | Re: VALUES clause memory optimization (was: Values list-of-targetlists patch...) |
| Previous Message | Joe Conway | 2006-08-03 00:18:39 | VALUES clause memory optimization (was: Values list-of-targetlists patch...) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2006-08-03 05:58:52 | Re: [HACKERS] Rebuilding DB from broken hardrive. |
| Previous Message | Bruce Momjian | 2006-08-03 02:57:17 | Re: 8.2 feature set |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-03 12:48:57 | Re: VALUES clause memory optimization (was: Values list-of-targetlists patch...) |
| Previous Message | Joe Conway | 2006-08-03 00:18:39 | VALUES clause memory optimization (was: Values list-of-targetlists patch...) |