Re: COPY COMMAND

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."