Re: Doubt regarding query parameter metadata

Giovani Garcia <giovani(dot)garcia(at)protonmail(dot)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