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