Fwd: Row description Metadata information
Not sure that previous email was sent correctly. If it was duplicated,
sorry for the inconvenience.
Hi, hackers,
I have one question related to returned information in the row description
for prepared statement.
For example Select $1 * 2 and then Bind 1.6 to it.
The returned result is correct and equal to 3.2, but type modifier in the
row description is equal to -1, which is not correct.
Does someone know where this modifier is calculated? Is this a bug or
intention behavior?
Best regards,
Aleksei Ivanov
Import Notes
Reply to msg id not found: CAN0E21OH2VGS7WzJbHPoeXqsNpnUvhmi48C23His4AVn89Ranw@mail.gmail.comReference msg id not found: CAN0E21OH2VGS7WzJbHPoeXqsNpnUvhmi48C23His4AVn89Ranw@mail.gmail.com
On Mon, Feb 15, 2021 at 05:25:55PM -0800, Aleksei Ivanov wrote:
Not sure that previous email was sent correctly. If it was duplicated, sorry
for the inconvenience.Hi, hackers,
I have one question related to returned information in the row description for
prepared statement.For example Select $1 * 2 and then Bind 1.6 to it.
The returned result is correct and equal to 3.2, but type modifier in the row
description is equal to -1, which is not correct.Does someone know where this modifier is calculated? Is this a bug or intention
behavior?
Postgres can't always propogate the type modifier for all expresions, so
it basically doesn't even try. For example, the modifier for || would
be very complex.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee