BUG #6701: IS NOT NULL doesn't work on complex composites
| От | rikard.pavelic@zg.htnet.hr | 
|---|---|
| Тема | BUG #6701: IS NOT NULL doesn't work on complex composites | 
| Дата | |
| Msg-id | E1ShNDt-00005k-8t@wrigleys.postgresql.org обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: BUG #6701: IS NOT NULL doesn't work on complex composites
            		
            		 Re: BUG #6701: IS NOT NULL doesn't work on complex composites Re: BUG #6701: IS NOT NULL doesn't work on complex composites  | 
		
| Список | pgsql-bugs | 
The following bug has been logged on the website: Bug reference: 6701 Logged by: Rikard Pavelic Email address: rikard.pavelic@zg.htnet.hr PostgreSQL version: 9.1.3 Operating system: Windows 7 Description:=20=20=20=20=20=20=20=20 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;
В списке pgsql-bugs по дате отправления: