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

Re: BUG #6701: IS NOT NULL doesn't work on complex composites

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: rikard(dot)pavelic(at)zg(dot)htnet(dot)hr
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6701: IS NOT NULL doesn't work on complex composites
Date: 2012-06-20 18:55:25
Message-ID: CAFj8pRAtZBjOPaW+-hBaE5rO5oFf0yp75+zp4xnB4tNP0HAmhA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello

it is not a bug - see
http://archives.postgresql.org/pgsql-hackers/2009-07/msg01525.php

Regards

Pavel Stehule

2012/6/20  <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>:
> The following bug has been logged on the website:
>
> Bug reference:      6701
> Logged by:          Rikard Pavelic
> Email address:      rikard(dot)pavelic(at)zg(dot)htnet(dot)hr
> PostgreSQL version: 9.1.3
> Operating system:   Windows 7
> Description:
>
> create type t AS (i int);
> create type complex as (t t, i int);
> create table bad(i int, c complex);
>
> insert into bad values(1, null);
> insert into bad values(1, ROW(null, 2));
> insert into bad values(1, ROW(ROW(1), 2));
>
> select * from bad;
> select * from bad where c is null;
>
> --This doesn't work as expected
> select * from bad where c is not null;
>
> --Fortunately a workaround
> select * from bad where NOT c is null;
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

In response to

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2012-06-20 19:08:15
Subject: Re: BUG #6701: IS NOT NULL doesn't work on complex composites
Previous:From: Chan PhamDate: 2012-06-20 18:23:44
Subject: log_truncate_on_rotation=on is not truncating

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