Re: COPY COMMAND

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: Savita <savita(at)india(dot)hp(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: COPY COMMAND
Date: 2002-11-26 11:28:47
Message-ID: 3DE3A847.15355.DB015E@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 26 Nov 2002 at 16:40, Savita wrote:

> What about the date field????

ISNULL didn't work on date field? That's surprising..

> Shridhar Daithankar wrote:
> > Umm.. Is this a text field? What happens when you select for string length=0?
> > IMO for a string/char field, NULL will be different than empty string but I am
> > still puzzled why '' did not work...

I am looking thr. documentation but I don't see any equivalent of char_length
for a timestamp.

Bye
Shridhar

--
One of the advantages of being a captain is being able to ask foradvice without
necessarily having to take it. -- Kirk, "Dagger of the Mind", stardate 2715.2

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Savita 2002-11-26 11:31:23 Re: COPY COMMAND
Previous Message Savita 2002-11-26 11:10:26 Re: COPY COMMAND