Skip site navigation (1) Skip section navigation (2)

Re: setObject on PGInterval throws "Unknown Type null"

From: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
To: "Kris Jurka" <books(at)ejurka(dot)com>,"Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: setObject on PGInterval throws "Unknown Type null"
Date: 2005-01-25 22:58:15
Message-ID: BAYC1-PASMTP037B5B1408A1601B3E163B95860@cez.ice (view raw or flat)
Thread:
Lists: pgsql-jdbc
"func(?)" will be rejected by the server at runtime if there is ambiguity,
but it could be coded as "func(cast(?) as sometype)" if ? can be null.

In the case of "? IS NULL", I don't understand how the type of the null 
would
affect the evaluation of this boolean expression.

Jean-Pierre Pelletier

----- Original Message ----- 
From: "Kris Jurka" <books(at)ejurka(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>; 
<pgsql-jdbc(at)postgresql(dot)org>
Sent: Tuesday, January 25, 2005 5:30 PM
Subject: Re: [JDBC] setObject on PGInterval throws "Unknown Type null"


>
>
> On Wed, 26 Jan 2005, Oliver Jowett wrote:
>
>> [ways to set null values for non-standard types]
>
> I'm kind of leaning to removing the restriction that nulls must be
> strongly typed.  Compared to the current workarounds the idea that a
> (very) few cases won't work isn't that bad.  What I recall "? IS NULL"
> won't work and "func(?)" could be ambiguous, but that doesn't stop you
> from specifying a type for these cases.  For non-null values we need the
> strong typing to ensure that we don't send data in a different format than
> the server expects, but this is not an issue with nulls.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly 


In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-01-25 23:10:51
Subject: Re: setObject on PGInterval throws "Unknown Type null"
Previous:From: Kris JurkaDate: 2005-01-25 22:30:30
Subject: Re: setObject on PGInterval throws "Unknown Type null"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group