Message-ID: <5574AD22.8010508@gmail.com>
Date: Sun, 07 Jun 2015 22:44:18 +0200
From: Danilo Fortunato <danilo.fortunato.2@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: What is the meaning of the N string operator ?
Content-Type: text/plain; charset=iso-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

In the SQL code related to Greenplum Database (which is based on 
PostgreSQL) generated by a query and reporting tool, a noticed a "N" 
operator put before a lot of strings.
For example:

case  when column_a <> N'#' then column_a
       when column_b <> N'#' then column_b
       else NULL
end

I executed this SQL code, and I found out that it is valid.

In the PostgreSQL documentation I didn't find a description of this 
operator (though it is not easy to search for).
However, I found a description of the E (escape) and B (binary) string 
operators.

Can anybody explain the meaning of the N string operator ?
Is there a section in the PostgreSQL documentation that describes it ?

Thanks,
Danilo Fortunato


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs