pc wrote:
oh yes! You all are exactly right.I exported a table and all nulls
became \N and when i imported it \n remained \N and did not convert to
NULL.So I updates all \N s with '' now.
Thank you all for your input.I got to learn a lot from you.
Since the empty string is different from NULL
On Jul 30, 3:27 am, [EMAIL PROTECTED] (Alban Hertroys) wrote:
> Nis Jørgensen wrote:
> > Alban Hertroys skrev:
>
> >> Presumably he wanted col2 like E'%N%'.
> >> But doesn't \N mean NULL, or would the OP be looking for literal '\N'
> >> strings in his data? Because if he's looking for NULLs it
wow! works for me! Thank you !!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Nis Jørgensen wrote:
> Alban Hertroys skrev:
>
>> Presumably he wanted col2 like E'%N%'.
>> But doesn't \N mean NULL, or would the OP be looking for literal '\N'
>> strings in his data? Because if he's looking for NULLs it may be better
>> to query for col2 IS NULL.
>
> My guess is that this
Alban Hertroys skrev:
> Presumably he wanted col2 like E'%N%'.
> But doesn't \N mean NULL, or would the OP be looking for literal '\N'
> strings in his data? Because if he's looking for NULLs it may be better
> to query for col2 IS NULL.
My guess is that this string was used to signify NULL i
Bertram Scharpf wrote:
> Hi,
>
> Am Freitag, 27. Jul 2007, 18:35:21 - schrieb pc:
>> I have a table test with columns col1 col2.col2 contains an entry
>> '\N' .I want to select all entries which have '\N' in col2.How do i
>> do that?
>>
>> select * from test where col2 like '\N' ;
>> select
Hi,
Am Freitag, 27. Jul 2007, 18:35:21 - schrieb pc:
> I have a table test with columns col1 col2.col2 contains an entry
> '\N' .I want to select all entries which have '\N' in col2.How do i
> do that?
>
> select * from test where col2 like '\N' ;
> select * from test where col2 like '\\N'
On Fri, 27 Jul 2007, pc wrote:
> Hi,
>
> I have a table test with columns col1 col2.col2 contains an entry
> '\N' .I want to select all entries which have '\N' in col2.How do i
> do that?
>
> select * from test where col2 like '\N' ;
> select * from test where col2 like '\\N' ;
select * from
Hi,
I have a table test with columns col1 col2.col2 contains an entry
'\N' .I want to select all entries which have '\N' in col2.How do i
do that?
select * from test where col2 like '\N' ;
select * from test where col2 like '\\N' ;
both return 0 rows.Could some one please tell me the right que