unable to call a function

Поиск
Список
Период
Сортировка
От giozh
Тема unable to call a function
Дата
Msg-id 1372953208844-5762590.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: unable to call a function  (Moshe Jacobson <moshe@neadwerx.com>)
Re: unable to call a function  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: unable to call a function  (giozh <giozh@yahoo.it>)
Список pgsql-general
i've write this function that search if inside a specified table there's a
specified value:

CREATE FUNCTION check_if_if_exist(id INTEGER, table_name character(50),
table_column character(20) ) RETURNS BOOLEAN AS $$

BEGIN
    RETURN EXECUTE 'SELECT EXISTS(SELECT * FROM table_name WHERE table_column =
id)';
END;

$$ LANGUAGE plpgsql

but when i try to call it i always receive an error and the function will
not call. where is the problem?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/unable-to-call-a-function-tp5762590.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Can't create plpython language
Следующее
От: boraldomaster
Дата:
Сообщение: Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?