Re: What is the meaning of the N string operator ? - Mailing list pgsql-docs

From Tom Lane
Subject Re: What is the meaning of the N string operator ?
Date
Msg-id 23797.1433713041@sss.pgh.pa.us
Whole thread Raw
In response to What is the meaning of the N string operator ?  (Danilo Fortunato <danilo.fortunato.2@gmail.com>)
List pgsql-docs
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


pgsql-docs by date:

Previous
From: Andreas Seltenreich
Date:
Subject: Re: What is the meaning of the N string operator ?
Next
From: "liuyuanyuan"
Date:
Subject: Failed in moving database objects to another tablespace