Row IS NULL question

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Row IS NULL question
Date: 2006-09-28 14:24:40
Message-ID: 451BDB28.4050201@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marlon Petry 2006-09-28 14:26:54 Backup and restore through JDBC
Previous Message Andrew Dunstan 2006-09-28 14:16:31 Re: [Pgbuildfarm-members] [HACKERS] Buildfarm alarms