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: [EMAIL PROTECTED]
                                                   WWW: http://www.sigaev.ru/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to