Re: [GENERAL] Empty date

2005-04-04 Thread Karsten Hilbert
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.

Re: [GENERAL] Empty date

2005-04-03 Thread Tom Lane
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. regard

Re: [GENERAL] Empty date

2005-04-03 Thread Keary Suska
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

Re: [GENERAL] Empty date

2005-04-03 Thread Karsten Hilbert
> 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 ch

Re: [GENERAL] Empty date

2005-04-03 Thread Bruno Wolff III
On Sun, Apr 03, 2005 at 15:46:18 +0200, Karsten Hilbert <[EMAIL PROTECTED]> wrote: > > > type " 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

Re: [GENERAL] Empty date

2005-04-03 Thread Karsten Hilbert
> > type " 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:

Re: [GENERAL] Empty date

2005-04-03 Thread Bruno Wolff III
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 ? " of type " cannot be less > than (nor more than nor equal to) " of

Re: [GENERAL] Empty date

2005-04-03 Thread Karsten Hilbert
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 ? " of type " cannot be less than (nor more than nor equal to) " of type ". If you want to express the valid idea of " of type " you are better off using a logical

Re: [GENERAL] Empty date

2005-04-02 Thread Andrus
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

Fw: [GENERAL] Empty date

2005-03-30 Thread Szmutku Zoltán
uot; > To: "Szmutku Zoltán" <[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 '. .

Re: [GENERAL] Empty date

2005-03-30 Thread Yudie Pg
> 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 inc

Re: [GENERAL] Empty date

2005-03-30 Thread Richard Huxton
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 c

[GENERAL] Empty date

2005-03-30 Thread Szmutku Zoltán
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.     Thanks : Zolta

RE: [GENERAL] Empty date field !

1999-07-07 Thread Greg Youngblood
7;.   Greg   Gregory S. Youngblood 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 a

Re: [GENERAL] Empty date field !

1999-07-07 Thread Christian Rudow
> 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

Currency field is too small (formerly: RE: [GENERAL] Empty Date Field)

1999-05-10 Thread Michael J Davis
CTED] > Subject: Re: [GENERAL] Empty Date Field > > Thank you very much. > > I have another question if you don't mind... > I live in Colombia (Sounth America) and on the currency works with numbers > > much higher than the ones used in dollars. For example we w