Danilo Fortunato writes:
> Can anybody explain the meaning of the N string operator ?
The SQL standard says that N'foo' is a literal of the data type NATIONAL
CHARACTER. PG supports this syntax (and the type name) but treats it the
same as plain character/varchar.
> Is there a section in the Po
Danilo Fortunato writes:
> Can anybody explain the meaning of the N string operator ?
> Is there a section in the PostgreSQL documentation that describes it ?
I couldn't find it in the manual either, but using it seems to yield
values of type char instead of varchar/text:
,
| scratch=# selec
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 exe
