Postgres Pro
Downloads
Home   >   mailing lists

Cast '' (blank) to null date - Mailing list pgsql-sql

From Mattis Jiderhamn
Subject Cast '' (blank) to null date
Date
Msg-id 9j8udq$fmo$1@news.tht.net
Whole thread Raw
Responses Re: Cast '' (blank) to null date  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Hi there everyone.
I'm trying to create a trigger so that, if I try to insert blank, that is
'', into a date field it will be converted to null so that I don't get ERROR:  Bad date external representation ''

I believe my ploblem is that I don't know the type of blank (''), and
therefore do not know what to cast from.
It seems it is not unknown.
Any other suggestions?

Thanks, Mattias Jiderhamn mattias@expertsystem.se

pgsql-sql by date:

Previous
From: David Stanaway
Date:
Subject: Re: example of [outer] join
Next
From: "Fons Rave"
Date:
Subject: Records exactly the same.