On Sat, May 29, 2010 at 11:05 AM, Dennis Gearon <gearond@sbcglobal.net> wrote:
> Can the whole three level, 4 member hierarchy be created in one, prepared statement(to avoid SQL injection),
transactionwithout 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