Re: query to match '\N'

From: Nis Jørgensen <nis(at)superlativ(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: query to match '\N'
Date: 2007-07-30 10:01:09
Message-ID: f8kctm$jc6$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2007-07-30 10:27:45 Re: query to match '\N'
Previous Message Alban Hertroys 2007-07-30 09:34:33 Re: query to match '\N'