plpython question

Поиск
Список
Период
Сортировка
От Sim Zacks
Тема plpython question
Дата
Msg-id 1683715459.20041019085839@compulab.co.il
обсуждение исходный текст
Ответы Re: plpython question
Re: plpython question
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Numeric user names
Следующее
От: Hagen Hoepfner
Дата:
Сообщение: Re: plpython question