public inbox for [email protected]  

help / color / mirror / Atom feed

From: Danilo Fortunato <[email protected]>
To: [email protected]
Subject: What is the meaning of the N string operator ?
Date: Sun, 07 Jun 2015 22:44:18 +0200
Message-ID: <[email protected]> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: What is the meaning of the N string operator ?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox