On 10/16/2017 05:24 PM, Eduardo Pérez Ureta wrote: > 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. >
So you're passing a timestamp value to PostgreSQL only to find out if it's NULL? I don't want to be rude, but that seems a bit ... strange.
Yes, it is a bit strange, but I am trying to not modify a working application.
> > You say PostgreSQL is strongly typed, but an unknown type is accepted > in the cases I presented before. >
As David already pointed out before, these examples are not equal. In the other cases PostgreSQL can easily infer the data type from other parts of the query (e.g. target column in an INSERT). But that's not the case here.
I still do not see why PostgreSQL cannot infer that the type is not required.
> > Do you mean that PostgreSQL is not following the SQL standard? >
Can you kindly point us to the part where SQL Standard requires the behavior you're requesting?
I do not have access to the SQL standard. I was just asking.