From: James M Doherty <jim@jdoherty.net>
To: pgsql-sql@postgresql.org
Subject: HOW TO HANDLE ZEROS IN DATE FIELD?
Date: Fri, 3 Sep 2004 09:36:44 -0500
Message-ID: <000401c491c3$6f4ca240$68363c90@ad.tri.sbc.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jim@jdoherty.net
Subject: Re: HOW TO HANDLE ZEROS IN DATE FIELD?
In-Reply-To: <000401c491c3$6f4ca240$68363c90@ad.tri.sbc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox