Re: What is the meaning of the N string operator ?

Danilo Fortunato <danilo.fortunato.2@gmail.com> 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 PostgreSQL documentation that describes it ?

I don't see it offhand.  I think it's pretty much useless/deprecated
anyway so I'm not sure it's worth documenting.

            regards, tom lane