Re: Why type coercion is not performed for parameters?

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: Marko Tiikkaja <marko(at)joh(dot)to>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why type coercion is not performed for parameters?
Date: 2017-05-05 10:58:32
Message-ID: f132bff8-4fcc-af50-b717-a5d36926c1b1@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 05.05.2017 13:29, Marko Tiikkaja wrote:
>
> But you know that the type of the literal "10" is int. If you're
> throwing that information away, surely that's a bug in your code.
>
Yes, in case of integer literal I can easily determine parameter type.
But in case of string literal I have to set UNKNOWNOID type otherwise a
lot of queries will not work.

>
> .m

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2017-05-05 11:10:10 Re: snapbuild woes
Previous Message Marko Tiikkaja 2017-05-05 10:29:08 Re: Why type coercion is not performed for parameters?