selecting from $1

Поиск
Список
Период
Сортировка
От pkelly@virtual.org.uk
Тема selecting from $1
Дата
Msg-id Pine.LNX.4.10.9908131151550.30951-100000@virtual.org.uk
обсуждение исходный текст
Ответы Re: [GENERAL] selecting from $1  (pkelly@virtual.org.uk)
Список pgsql-general
hi,
  using plpgsql im trying to do a select using $1 as the variable, this is
the query:

CREATE FUNCTION find_user (text) RETURNS text AS '
DECLARE
 ip text;
BEGIN
        select smtpip into ip from user_services where domain=$1;
        IF NOT FOUND THEN
           RAISE EXCEPTION ''Cant Find smtpip address for %'',$1;
           return;
        END IF;
        return ip;
END;
' LANGUAGE 'plpgsql';

i get the following error:

ERROR:  There is no operator '=$' for types 'varchar' and 'int4'
    You will either have to retype this query using an explicit cast,
    or you will have to define the operator using CREATE OPERATOR


if i change the =$1 to a 'like' then it works fine..help!

Paul
----------------------------------------------
Paul Kelly        pkelly@virtual.org.uk
U-NET Internet Noc    Some day now!


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

Предыдущее
От: Remigiusz Sokolowski
Дата:
Сообщение: how to compile postgres with some module
Следующее
От: Roberto Moreda
Дата:
Сообщение: About triggers