Re: FUNCTION problem

Sky <sky@sylvio.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