On Monday 17 January 2005 01:54 am, Hong Yuan wrote: I entered the multilineversion of this function exactly as written here and it ran properly. This was with version 8.0 of Postgres. You might want to do a /df+ circ in psql to see if your editor is putting a space at the beginning of line 2. > Hi, > > I am biwildered at how to create a multi-line plpython function in > Postgres. When I create the function in one line like this: > > CREATE or REPLACE FUNCTION circ (float) > RETURNS float AS 'from math import pi; return 2*pi*args[0]' LANGUAGE > plpythonu; > > and then use SELECT circ(1) to test it, it runs well. > > But if I try to make the code looks better by separating it into > mulitple lines, like this: > > CREATE or REPLACE FUNCTION circ (float) > RETURNS float AS ' > from math import pi > return 2*pi*args[0]' LANGUAGE plpythonu; > > I got an error message: > > ERROR: plpython: could not compile function "circ" > DETAIL: exceptions.SyntaxError: invalid syntax (line 2) > > How to get Postgres to accept a normal looking python function? > > Greetings -- Adrian Klaver aklaver@xxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
