From: | Danilo Fortunato <danilo(dot)fortunato(dot)2(at)gmail(dot)com> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | What is the meaning of the N string operator ? |
Date: | 2015-06-07 20:44:18 |
Message-ID: | 5574AD22.8010508@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Seltenreich | 2015-06-07 21:32:43 | Re: What is the meaning of the N string operator ? |
Previous Message | Andreas Seltenreich | 2015-06-05 08:00:34 | [PATCH] doc: Fix typo in logicaldecoding.sgml. |