Re: [GENERAL] plpy prepare problem

2007-04-03 Thread Adrian Klaver
On Sunday 01 April 2007 9:09 am, jlowery wrote: > I'm having a bit of a problem getting plpython's prepare to work > properly: > > CREATE OR REPLACE FUNCTION batch_item_reversal(b batch_item) > RETURNS "varchar" AS > $BODY$ > > if b['reversal_flag'] == 'Y': > sql = plpy.prepare(""" >

[GENERAL] plpy prepare problem

2007-04-02 Thread jlowery
I'm having a bit of a problem getting plpython's prepare to work properly: CREATE OR REPLACE FUNCTION batch_item_reversal(b batch_item) RETURNS "varchar" AS $BODY$ if b['reversal_flag'] == 'Y': sql = plpy.prepare(""" SELECT batch_item_number FROM batch_it