Re: query to match '\N' - Mailing list pgsql-general

From Nis Jørgensen
Subject Re: query to match '\N'
Date
Msg-id f8kctm$jc6$1@sea.gmane.org
Whole thread Raw
In response to Re: query to match '\N'  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: query to match '\N'
List pgsql-general
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 in the file
originally imported into the db.

Nis



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: query to match '\N'
Next
From: Alban Hertroys
Date:
Subject: Re: query to match '\N'