[fpc-pascal] PostgreSQL: ERROR: operator does not exists: uuid = text

[silvioprog]

2013/9/5 Michael Van Canneyt <michael at freepascal.org>

> On Thu, 5 Sep 2013, silvioprog wrote:
>
>> Thank guys, fixed with:
>>
>> q.SQL.Add('where t1.id::text = :id');
>>
>
> I recommend against this.
>
> It will do the conversion for each record that is tested. This takes time.
>
> If you do the conversion on the parameter, it will be done only once, when
> the parameter is set (or so it should).
>
> Michael.


Hm... you're absolutely right. I'll do as you advised me before (with cast
in param). Thanks again! (y)

-- 
Silvio Clécio
My public projects - github.com/silvioprog
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20130905/565041d0/attachment.html>