From: | "Matt L(dot)" <survivedsushi(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | booleans and nulls |
Date: | 2005-08-21 02:25:57 |
Message-ID: | 20050821022557.21501.qmail@web35204.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Out of curiousity,
1. Does a boolean column occupy 1byte of disk whether
or not the value is null or not?
2. Is matching on IS NULL or = 0 more efficient?
3. If I ix'd columns w/ null does postgres know
whatevers not indexed is null or would their be no
point?
I currently utilize null fields as 'not a value' has
meaning in a program i've been working on as I don't
want to put false in every column when i only need a
couple with a true/false value.
I'm not joining tables on NULLS, just filtering w/
them.
Thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Matt A. | 2005-08-21 19:56:27 | returning inserted id |
Previous Message | Matt L. | 2005-08-21 01:40:23 | nullif('','') on insert |