| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | Dennis Gearon <gearond(at)sbcglobal(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: child/parent creation |
| Date: | 2010-05-29 19:52:23 |
| Message-ID: | AANLkTinsb_Q662DnywF4O3u4iByk4OCv2Zee98cPTv1t@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, May 29, 2010 at 11:05 AM, Dennis Gearon <gearond(at)sbcglobal(dot)net> wrote:
> Can the whole three level, 4 member hierarchy be created in one, prepared statement(to avoid SQL injection), transaction without shuttling any information back and forth between the database and the calling script?
Not yet, but possible in 9.1 this can be done using write-able CTEs if
they are accepted.
http://pgexperts.com/document.html?id=38
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2010-05-29 20:29:50 | Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking |
| Previous Message | Tom Wilcox | 2010-05-29 18:27:53 | Re: Out of Memory and Configuration Problems (Big Computer) |