agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: David Johnston <polobo@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: NULLs and composite types
Date: Thu, 12 Dec 2013 11:25:31 -0800 (PST)
Message-ID: <1386876331115-5783187.post@n5.nabble.com> (raw)
In-Reply-To: <52A9010D.3070202@ultimeth.com>
References: <52A9010D.3070202@ultimeth.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Dean Gibson (DB Administrator)-2 wrote
> What's going on? I can provide more detail if requested. Of course, an
> obvious workaround is to use in a VIEW:
>
> ... NULLIF( location, ROW( NULL, NULL )::"GeoPosition" ) ...
>
> but I'd like to know the cause.
Cannot test right now but the core issue is that IS NULL on a record type
evaluates both the scalar whole and the sub-components. Try using IS [NOT]
DISTINCT FROM with various target expressions and see if you can get
something more sane.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/NULLs-and-composite-types-tp5783027p5783187.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (5+ messages) latest in thread
Message-ID: <1386876331115-5783187.post@n5.nabble.com>
Permalink: ../1386876331115-5783187.post@n5.nabble.com/
Also on: postgresql.org/message-id/1386876331115-5783187.post@n5.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: polobo@yahoo.com
Subject: Re: NULLs and composite types
In-Reply-To: <1386876331115-5783187.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox