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
