Re: Query performance problem - Mailing list pgsql-sql

From Kenneth Gonsalves
Subject Re: Query performance problem
Date
Msg-id 200503181049.47566.lawgon@thenilgiris.com
Whole thread Raw
In response to Re: Query performance problem  (Richard Huxton <dev@archonet.com>)
Responses Re: Query performance problem  (Ragnar Hafstað <gnari@simnet.is>)
Re: Query performance problem  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!


pgsql-sql by date:

Previous
From: Theo Galanakis
Date:
Subject: Re: Process priority.
Next
From: Ragnar Hafstað
Date:
Subject: Re: Query performance problem