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( SELECT

[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_item