On Sun, Apr 03, 2005 at 08:54:12PM -0400, Tom Lane wrote:
area= select 'infinity'::timestamp::date is null;
?column?
--
t
(1 row)
Ah, thanks.
I think this is a bug BTW. If we can't convert the value correctly,
we ought to raise an error not return NULL.
Which is *why* I
On Thu, Mar 31, 2005 at 09:43:27AM +0300, Andrus wrote:
Empty data is a date which is less that all other dates.
Why would that be ? Empty of type unknown cannot be less
than (nor more than nor equal to) not empty of type date.
If you want to express the valid idea of less-than-anything
of type
On Sun, Apr 03, 2005 at 11:06:22 +0200,
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Thu, Mar 31, 2005 at 09:43:27AM +0300, Andrus wrote:
Empty data is a date which is less that all other dates.
Why would that be ? Empty of type unknown cannot be less
than (nor more than nor equal to)
type date or some such. However the best would be to use
-infinity.
+/- infinity are only available as timestamps, not dates.
Hm, any particular reason why ? Apart from no one having
gotten around to doing it...
Strange enough, on 7.4.6 I am unsure as to how to interpret
the output of:
On Sun, Apr 03, 2005 at 15:46:18 +0200,
Karsten Hilbert [EMAIL PROTECTED] wrote:
type date or some such. However the best would be to use
-infinity.
+/- infinity are only available as timestamps, not dates.
Hm, any particular reason why ? Apart from no one having
gotten around to
area= select 'infinity'::timestamp::date is null;
?column?
--
t
(1 row)
Ah, thanks.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end of broadcast)---
TIP 5: Have you checked
on 3/30/05 11:43 PM, [EMAIL PROTECTED] purportedly said:
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
Karsten Hilbert [EMAIL PROTECTED] writes:
area= select 'infinity'::timestamp::date is null;
?column?
--
t
(1 row)
Ah, thanks.
I think this is a bug BTW. If we can't convert the value correctly,
we ought to raise an error not return NULL.
regards, tom lane
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
Hi ,
Thanks your previous help. I have a new question
: how to store emptyvalue to date field ? ( I always get error
message, in vain use any format)In my client be empty value for date
fields (' . . ') , and Iwould like to use
NULL values and empty values also.
Thanks : Zoltan
Szmutku Zoltán 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
In my client be empty value for date fields ('. . ') , and I would
like to use NULL values and empty values also.
What is your reason to put empty value ('') as alternative of null value?
---(end of broadcast)---
TIP 7: don't forget to
[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 1:01 PM
Subject: Re: [GENERAL] Empty date
Szmutku Zoltán wrote:
Hi,
Valid or invalid ... indifferent .
MySql can store '. . ' or '.00.00' values to date field.
Formerly I use Mysql , and now change to Postgres (single
I'm desperately searching how to UPDATE a date-field with an empty
value ?
use escape : \N (represents NULL)
Chris
--
Christian Rudow E-Mail: [EMAIL PROTECTED]
ThinX networked business servicesStahlrain 10,
blood
ext 2164
-Original Message-
From: Erik Colson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 06, 1999 3:36 PM
To: Postgres-General
Subject: [GENERAL] Empty date field !
Hello !
I'm desperately searching how to UPDATE a date-field with an empty value ?
I really just wan
15 matches
Mail list logo