| From: | Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Query::targetList and RETURNING |
| Date: | 2009-11-10 10:29:42 |
| Message-ID: | 4AF94096.1090309@cs.helsinki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
While working on writeable CTEs, I noticed I have to special-case the
output of a Query node frequently because in INSERT/UPDATE/DELETE query
targetList is the target list which is used for modifying the result
relation and returningList is the output of that Query. However, this
is different from SELECT where targetList actually is the output of that
Query node. Attached is a patch which avoids this special-casing by
making Query's targetList always be the output target list. The target
list for the result relation is stored separately. The patch needs a
bit more work but I'll be glad to do it if people think this is useful.
Thoughts?
Regards,
Marko Tiikkaja
| Attachment | Content-Type | Size |
|---|---|---|
| querytarget.patch | text/plain | 28.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandra Roy | 2009-11-10 10:37:25 | Re: PostgreSQL 8.3.8 on AIX5.3 : compilation failed |
| Previous Message | rgc.tech | 2009-11-10 10:08:34 | accent-insensitive |