From: | "Andrus" <noeetasoftspam(at)online(dot)ee> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Empty date |
Date: | 2005-03-31 06:43:27 |
Message-ID: | d2g831$v28$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a ODBC client which uses empty dates in its native data engine.
Unfortunately, empty data causes error if trying to store it.
This is serious Postgres limitation.
For a partial fix ODBC driver or postgres should convert empty dates to
NULLs automatically. This is better that producing error.
>> How can " " be a valid date? <<
>> You might want to reconsider your design. <<
Using your logic, I can ask: How can be 0 valid number ? If there is not
empty dates, number 0 cannot be also legal.
Empty data is a date which is less that all other dates. It can be used in
comparisons.
In contract, NULL date means that date is not entered.
Andrus Moor
"Richard Huxton" <dev(at)archonet(dot)com> wrote in message
news:424A7831(dot)6040805(at)archonet(dot)com(dot)(dot)(dot)
> Szmutku Zoltn wrote:
>> Hi ,
>>
>> Thanks your previous help. I have a new question : how to store
>> empty value to date field ? ( I always get error message, in vain use
>> any format ) In my client be empty value for date fields (' . .
>> ') , and I would like to use NULL values and empty values also.
>
> How can " " be a valid date?
>
> You might want to reconsider your design.
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2005-03-31 07:00:12 | Compriere or other ERP database dump for Postgres |
Previous Message | Jeffrey Melloy | 2005-03-31 06:43:08 | Re: Days in month query |