Postgres Pro
Downloads
Home   >   mailing lists

HOW TO HANDLE ZEROS IN DATE FIELD? - Mailing list pgsql-sql

From James M Doherty
Subject HOW TO HANDLE ZEROS IN DATE FIELD?
Date
Msg-id 000401c491c3$6f4ca240$68363c90@ad.tri.sbc.com
Whole thread Raw
Responses Re: HOW TO HANDLE ZEROS IN DATE FIELD?
List pgsql-sql
Tree view 
I have a project that is taking input from another system. I have certain
columns defined as 'Date'

Columns. On input I will get '000000' in this field which causes the insert
to fail. I have read the

docs on default and it is unclear to me if this will work. Does anyone have
experience in solving

this problem. The other alternative I thought of was to write a trigger to
fix it ??



James M Doherty
jim@jdoherty.net
Georgetown, TX 78626
"There is no luck without discipline" IRISH PROVERB

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: aggregate function stddev
Next
From: "Thomas Wegner"
Date:
Subject: SQL99 "with recursive" question