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