Skip site navigation (1) Skip section navigation (2)

Re: Using null date fields to indicate active/expired records

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: josh(at)agliodbs(dot)com
Cc: sfpug(at)postgresql(dot)org
Subject: Re: Using null date fields to indicate active/expired records
Date: 2004-08-10 12:50:46
Message-ID: 4118C4A6.9030408@pukkasoft.com (view raw or flat)
Thread:
Lists: sfpug
Josh Berkus wrote:
> Which is faster depends on your query structure and the distribution of your 
> data; that's the other reason not to make decisions on this basis now.  If 
> you want a serious answer on this, please post your current table structure 
> and an explanation of what kind of data is kept in the various fields and how 
> you query it.

My database for this project is about 40 tables.  I don't know where the 
line is drawn on this list between postgres specific discussion and data 
model review.

I am making a lot of changes right now including this archived/deleted 
indicator so I would welcome the opportunity to review my plans if it's 
acceptable, but I don't want to abuse the list.


Brian



In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2004-08-10 22:48:40
Subject: Re: Using null date fields to indicate active/expired records
Previous:From: David AlbanDate: 2004-08-08 23:14:06
Subject: SIG-BEER-WEST: NEXT Saturday 8/14 in Mountain View

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group