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

[Michael Van Canneyt]

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.