From: | pkelly(at)virtual(dot)org(dot)uk |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] selecting from $1 |
Date: | 1999-08-13 13:12:30 |
Message-ID: | Pine.LNX.4.10.9908131411290.31803-100000@virtual.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
ahh well how dumb do i feel:)
this doesnt work:
select smtpip into ip from user_services where domain=$1;
this does:
select smtpip into ip from user_services where domain = $1;
doh!
Paul
----------------------------------------------
Paul Kelly pkelly(at)virtual(dot)org(dot)uk
U-NET Internet Noc Some day now!
On Fri, 13 Aug 1999 pkelly(at)virtual(dot)org(dot)uk wrote:
> 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(at)virtual(dot)org(dot)uk
> U-NET Internet Noc Some day now!
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bart Ogryczak | 1999-08-13 13:20:36 | Numeric constants in PostgreSQL? |
Previous Message | amy cheng | 1999-08-13 12:07:34 | how perl get trigger info? |