Constantin Teodorescu <teo(at)flex(dot)ro> writes:
> I have replaced:
> ... where id=\'\\$1\'
> with
> ... where id=\\$1
> and the error is now:
> ERROR: Unable to identify an operator '=$' for types 'character
> varying' and 'integer'
Wup, you needed a space:
... where id = \\$1
BTW, if id is varchar it would be better to define the function as
accepting varchar not bpchar, no?
regards, tom lane