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

Reply via email to