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

BUG #2418: number & date & time

From: "James" <james(at)mercstudio(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2418: number & date & time
Date: 2006-05-02 10:36:52
Message-ID: 200605021036.k42AaqX1055844@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2418
Logged by:          James
Email address:      james(at)mercstudio(dot)com
PostgreSQL version: 8.1
Operating system:   Microsoft Windows XP Professional
Description:        number & date & time
Details: 

hi,

we would like to have convinience data conversion from datatype number of
value '' as null and datatype date / timestamp / timestampz of value '' as
null...

so far, postgresql will reject those value for number and date / time field
when it's empty string '' (as invalid date value or invalid number value)

it would be nice to have it auto converted :)

Responses

pgsql-bugs by date

Next:From: Peter BrantDate: 2006-05-02 16:42:33
Subject: Re: BUG #2371: database crashes with semctl failed
Previous:From: JamesDate: 2006-05-02 10:34:12
Subject: BUG #2417: bug for finding string in column

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