Giovani Garcia <giovani.garcia@protonmail.com> writes:
>> Is that theexact query you're issuing?
> Yes, that's the exact query.
Oh ... after actually trying the program you sent, I realized you are
looking at the wrong thing, or at least asking about something other
than what I thought you were asking about. You are querying
PQparamtype(), that is, the type of the symbol $1, not the type of
the returned column "key" which is what I thought you meant. As I
explained before, varchar has no operators, particularly not equality;
so "value = $1" is interpreted using the text = text operator, making
it effectively "value::text = $1::text". Thus $1 is resolved as type
text.
regards, tom lane