Hi, Am Freitag, 27. Jul 2007, 18:35:21 -0000 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' ;
select * from test where col2 like E'\\\\N'; select * from test where col2 = E'\\N'; Why use `like' here at all? Bertram -- Bertram Scharpf Stuttgart, Deutschland/Germany http://www.bertram-scharpf.de ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
