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

[silvioprog]

Hello,

I can't understand how to open a query filtering by a field of type GUID.

The error message is below (translated from BR to US):

TPQConnection: Preparation of query failed. (PostgreSQL: ERROR: operator
does not exist: uuid = text
LINE 3: where t1.id = $ 1
                     ^
HINT: No operator corresponds with the name(s) and type(s) of argument(s)
informed. You need to add explicit type casts.

I'm sending a small example to reproduce this error in attached. I'm also
sending the script that creates the tables.

Has anyone had this problem?

-- 
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/20130904/7c461786/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: uuid_fk.zip
Type: application/zip
Size: 2128 bytes
Desc: not available
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20130904/7c461786/attachment.zip>