Obtain boolean value of expression in PLPGSQL
От | Max Speransky |
---|---|
Тема | Obtain boolean value of expression in PLPGSQL |
Дата | |
Msg-id | 20031104100616.GJ64762@lucky.net обсуждение исходный текст |
Ответы |
Re: Obtain boolean value of expression in PLPGSQL
Re: Obtain boolean value of expression in PLPGSQL Re: Obtain boolean value of expression in PLPGSQL |
Список | pgsql-general |
Hello My task is to validate expression and get value of it in boolean variable. I try to do following: CREATE OR REPLACE FUNCTION get_value(integer) RETURNS boolean AS' DECLARE Ret boolean; Op TEXT = ''=''; BEGIN Ret := 3 || Op || $1; RETURN Ret; END; ' language 'plpgsql'; when I try to execute this function I get such result: bill=# select get_value(3); WARNING: Error occurred while executing PL/pgSQL function get_value WARNING: line 6 at assignment ERROR: Bad boolean external representation '3=3' bill=# So, how can I explain that resulting type must be boolean ? Also, I try to play with SELECT INTO with same result. -- ... All opinions expressed are mine and not those of my employer. Yours, Max [Msg N 2419] ------------------------------------------- mailto: mx@lucky.net phone: +380-44-2054455
В списке pgsql-general по дате отправления: