I had tried it exactly the way I wrote it in python as a function and it worked.
Just in case I tried changing it to return ("OK") as you suggested and got the same error. Thank You Sim Zacks IT Manager CompuLab 04-829-0145 - Office 04-832-5251 - Fax ________________________________________________________________________________ I don't know plpythonu but python ;-) As I really understood your problem you want to return strings. In Pytho return("OK" ) should work ;-) Hagen Sim Zacks wrote: >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 > > > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly