Re: Query performance problem

From: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: weberp(at)paradise(dot)net(dot)nz, pgsql-sql(at)postgresql(dot)org
Subject: Re: Query performance problem
Date: 2005-03-18 05:19:47
Message-ID: 200503181049.47566.lawgon@thenilgiris.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday 17 Mar 2005 7:35 pm, Richard Huxton wrote:

> Not necessarily. NOT NULL here helps to ensure you can add values
> together without the risk of a null result. There are plenty of
> "amount" columns that should be not-null (total spent, total
> ordered etc).

that makes sense - but is it necessary to have a not null constraint
when there is a default value?

--
regards
kg

http://www.livejournal.com/users/lawgon
tally ho! http://avsap.sourceforge.net
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ragnar Hafstað 2005-03-18 07:32:52 Re: Query performance problem
Previous Message Theo Galanakis 2005-03-18 00:32:41 Re: Process priority.