Re: NULL values or not? - Mailing list pgsql-sql

From Archibald Zimonyi
Subject Re: NULL values or not?
Date
Msg-id Pine.LNX.4.21.0112211628390.21359-100000@valdez.netg.se
Whole thread Raw
In response to Re: NULL values or not?  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
Responses Re: NULL values or not?
List pgsql-sql

> What is the problem with nulls? why are they bad??
> 
NULLs are not bad, I have never claimed them to be. I try to avoid them
personally, which tends to make my number of tables many, but with fewer
lines usually since I don't have any NULLS.

However the current structure I have takes too long time (at least I think
so) and when I used VACUUM ANALYZE I went from roughly a 1 second query to
a 1 minute query. In my opinion that should not happen.

And if I have a structure with the following data:

CREATE TABLE person
( person_id int2, FirstName text, LastName text, phone_id int2
);

CREATE TABLE phonenumbers
( phone_id int2, phonenumber
);

where in table person phone_id could be NULL.

I would still have to join together my tables in order to retrieve all
info with a left join.

So again, I have no problems with NULLS, I just would like someone to
share when they use them contra when they don't.

Archie




pgsql-sql by date:

Previous
From: "Aasmund Midttun Godal"
Date:
Subject: Re: NULL values or not?
Next
From: "Josh Berkus"
Date:
Subject: Re: NULL values or not?