Re: COPY COMMAND

What about the date field????

Shridhar Daithankar wrote:

> On 26 Nov 2002 at 16:02, Savita wrote:
>
> > Hi,
> > I am able to insert the null field using \N in the text file,but while retiving
> > the data I am not able to retrive it.
> >
> > After inserting data I tried this select statement
> >
> > select * from os_customer_master where updated_by=' ';
> > and
> > select * from os_customer_master where updated_by=null;
> >
> > but it gives 0 rows.then how will I select this values.
>
> 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...
>
> Bye
> Shridhar
>
> --
> QOTD: "Our parents were never our age."
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------