Re: Date question.... - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Date question....
Date
Msg-id 20030522162400.GA4487@wolff.to
Whole thread Raw
In response to Date question....  ("Kovalcik, Mike A [ITS]" <mkoval01@sprintspectrum.com>)
List pgsql-admin
On Thu, May 22, 2003 at 10:50:10 -0500,
  "Kovalcik, Mike A [ITS]" <mkoval01@sprintspectrum.com> wrote:
> Is there a better way to do this?

How are you using the data?

Having NULL represent unknown is a reasonable way to do this.

Even if you delete the date entries, when you join the table back
with your main id table, you are most likely want to use an outer
join which will result in the missing birthdates being represented
as nulls anyway.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: After VACUUM, statistics become skewed
Next
From: Alex.H.Pollock@WellsFargo.COM
Date:
Subject: audit trail