From: Tom Lane <tgl@sss.pgh.pa.us>
To: Giovani Garcia <giovani.garcia@protonmail.com>
cc: "pgsql-interfaces@lists.postgresql.org"
 <pgsql-interfaces@lists.postgresql.org>
Subject: Re: Doubt regarding query parameter metadata
In-reply-to: 
 <nMumDcadzPE6aT81ly0k9zB6WOJygh4VWyFxmkMthwpZnH7xJcwwOGLZyfFQh6Hassdt3PKBiMmjOSh26X81prUXfEaWRYT1ukI8QBOCfxE=@protonmail.com>
References: 
 <eCpNID63M_eEUgOvB_39vy2LH_FaR9YS3hoUp7fYHbsKOQp9OzOfGglSQV3Cs50ajXJK3DBpZ-fma6qCawNyfX2Py3jnP7IOhr4FTUcbGBk=@protonmail.com>
 <3396840.1617286460@sss.pgh.pa.us>
 <nMumDcadzPE6aT81ly0k9zB6WOJygh4VWyFxmkMthwpZnH7xJcwwOGLZyfFQh6Hassdt3PKBiMmjOSh26X81prUXfEaWRYT1ukI8QBOCfxE=@protonmail.com>
Comments: In-reply-to Giovani Garcia <giovani.garcia@protonmail.com>
	message dated "Thu, 01 Apr 2021 15:30:05 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3457547.1617300420.1@sss.pgh.pa.us>
Date: Thu, 01 Apr 2021 14:07:00 -0400
Message-ID: <3457548.1617300420@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3457548.1617300420%40sss.pgh.pa.us>
Precedence: bulk

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