Multiline plpython procedure
От | Hong Yuan |
---|---|
Тема | Multiline plpython procedure |
Дата | |
Msg-id | 41EB8B52.7020303@homemaster.cn обсуждение исходный текст |
Ответы |
Re: Multiline plpython procedure
|
Список | pgsql-general |
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 -- HONG Yuan Homemaster Trading Co., Ltd. No. 601, Bldg. 41, 288 Shuangyang Rd. (N) Shanghai 200433, P.R.C. Tel: +86 21 55056553 Fax: +86 21 55067325 E-mail: hongyuan@homemaster.cn
В списке pgsql-general по дате отправления: