query to match '\N'

From: pc <chavanpriya(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: query to match '\N'
Date: 2007-07-27 18:35:21
Message-ID: 1185561321.042928.238280@i13g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 query?

Thanks
Priya

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edward Macnaghten 2007-07-27 18:50:05 Re: How best to represent relationships in a database generically?
Previous Message Lincoln Yeoh 2007-07-27 18:23:57 How best to represent relationships in a database generically?