What is the meaning of the N string operator ?

Поиск
Список
Период
Сортировка
От Danilo Fortunato
Тема What is the meaning of the N string operator ?
Дата
Msg-id 5574AD22.8010508@gmail.com
обсуждение исходный текст
Ответы Re: What is the meaning of the N string operator ?  (Andreas Seltenreich <seltenreich@gmx.de>)
Re: What is the meaning of the N string operator ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: What is the meaning of the N string operator ?  (Danilo Fortunato <danilo.fortunato.2@gmail.com>)
Список 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


В списке pgsql-docs по дате отправления:

Предыдущее
От: Andreas Seltenreich
Дата:
Сообщение: [PATCH] doc: Fix typo in logicaldecoding.sgml.
Следующее
От: Andreas Seltenreich
Дата:
Сообщение: Re: What is the meaning of the N string operator ?