From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Eduardo Pérez Ureta <edpeur(at)gmail(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14853: Parameter type is required even when the query does not need to know the type |
Date: | 2017-10-16 15:49:12 |
Message-ID: | CAFj8pRCzPgCQjiz1m2073_502jkOp-P4F6iG+cK8FVG_KhvGmg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
2017-10-16 17:24 GMT+02:00 Eduardo Pérez Ureta <edpeur(at)gmail(dot)com>:
> I have an application that I am trying to make it work in PostgreSQL and
> PostgreSQL seems to be the only database that does not support queries like:
> SELECT 1 WHERE ? IS NULL
> with a Java setTimestamp parameter.
>
> You say PostgreSQL is strongly typed, but an unknown type is accepted in
> the cases I presented before. Do you mean that PostgreSQL is not following
> the SQL standard?
>
this case is one, where datatype cannot be detected from context, and
Postgres requires it.
There is another question if there is not some issue on Java maybe JDBC
side.
Regards
Pavel
> On Oct 16, 2017 4:03 PM, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
>> On Sun, Oct 15, 2017 at 10:40 PM, Eduardo Pérez Ureta <edpeur(at)gmail(dot)com>
>> wrote:
>>
>>> My example is even better!
>>> There is no need to infer the type as it is not needed!
>>> PostgreSQL should be able to infer that no type is needed.
>>>
>>
>> It could - but since SQL is a strongly typed language it doesn't have
>> that luxury.
>>
>> The original thread you pointed to complained about the regression from
>> protocol v2 to protocol v3. Is that your complaint too or do you have some
>> other use case?
>>
>> David J.
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2017-10-16 16:27:39 | Re: BUG #14858: Inaccurate estimations after bulk delete and bulk insert |
Previous Message | Andrew Gierth | 2017-10-16 15:41:29 | Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup |