Row IS NULL question

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Row IS NULL question
Дата
Msg-id 451BDB28.4050201@sigaev.ru
обсуждение исходный текст
Ответы Re: Row IS NULL question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I'm playing around NULL. Docs says that
"A row value is considered not null if it has at least one field that is not 
null." and "SELECT ROW(table.*) IS NULL FROM table;  -- detect all-null rows"

So, I try:

wow=# \d tst          Table "public.tst" Column |       Type       | Modifiers
--------+------------------+----------- a      | double precision | b      | double precision |


% echo 'SELECT count(*) FROM tst WHERE a IS NULL AND b IS NULL;' | psql wow 

SET count
-------     6
(1 row)

But ROW() IS NULL doesn't find anything:
% echo 'SELECT ROW(tst.*) IS NULL FROM tst;' | psql wow  | grep 't'
% echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql wow
SET count
-------     0
(1 row)

What do I do wrong? Version of postgres - today's HEAD.


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mike Bassett
Дата:
Сообщение: Install on Windows XP
Следующее
От: "Marlon Petry"
Дата:
Сообщение: Backup and restore through JDBC