uuid array example?

Brian Jones <[email protected]> Fri, 26 Mar 2010 15:55:21 -0400
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]>
Hi all,

I have the privilege of migrating a lot of php code over to Python, and came
across a SQL query embedded in the PHP code that looks kinda like this:


SELECT widgets.shipped_by_id( :widget_id, :cust_id, CAST(' . $order->
'item_ids'} ) . ' AS uuid[])

I noticed that psycopg2 now supports the uuid array in the docs, but the
code example was a little confusing, and it didn't really cover the arrays.
Is it enough to create a python list populated with Python uuid values? Do I
then have to manually run the array through UUID_adapter or something in
order to get a value I can use in a query?

Thanks.

-- 
Brian K. Jones
Python Magazine  http://www.pythonmagazine.com
My Blog          http://www.protocolostomy.com

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg