| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Sky <sky(at)sylvio(dot)hu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FUNCTION problem |
| Date: | 2004-04-02 07:14:05 |
| Message-ID: | 23542.1080890045@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sky <sky(at)sylvio(dot)hu> writes:
> SELECT user_id FROM person WHERE uid=$1 AND pwd=$2;
> ERROR: Unable to identify an operator '=$' for types 'character' and
> 'integer
You need spaces:
SELECT user_id FROM person WHERE uid= $1 AND pwd= $2;
This is fixed as of PG 7.4, IIRC. Prior to that it's a feature not a
bug ;-) because we had a different definition of what an operator name
could be.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Musielak | 2004-04-02 07:17:47 | Re: 7.2.3-7.4.2 migration |
| Previous Message | Durai | 2004-04-02 07:07:53 | PostgreSQL 7.4.2 warnings in HPUX IPF: LOG: could not resolve "localhost": host nor service provided |