I have the following function and I am getting an invalid syntax error when I try to run it. I have tried the function a number of ways including with named parameters and non-named parameters using the args array. I also tried it with a tab at the beginning and without. I've also tried with the $$ and with single quotes and the double single quoting all the existing single quotes.
Any help would be greatly appreciated. create or replace function BatchBalanceStatus(balance int, needed int, freestock int) returns varchar as $$ if balance < 0: return 'Unhandled' elif freestock >= needed: return 'OK' else: return 'Ordered' $$ language plpythonu Thank You Sim Zacks IT Manager CompuLab 04-829-0145 - Office 04-832-5251 - Fax ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org