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