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
|
| Список | 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 по дате отправления: