Re: What's wrong in this pltcl function ? - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: What's wrong in this pltcl function ?
Date
Msg-id 12329.1034606693@sss.pgh.pa.us
Whole thread Raw
In response to Re: What's wrong in this pltcl function ?  (Constantin Teodorescu <teo@flex.ro>)
List pgsql-interfaces
Constantin Teodorescu <teo@flex.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


pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: What's wrong in this pltcl function ?
Next
From: Constantin Teodorescu
Date:
Subject: Re: What's wrong in this pltcl function ?