Re: Empty date

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
>