On Sat, May 29, 2010 at 11:05 AM, Dennis Gearon <gearond@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
