Re: [HACKERS] nvarchar notation accepted?

2010-07-03 Thread Bruce Momjian
Peter Eisentraut wrote: On m?n, 2010-06-07 at 12:56 -0500, Jaime Casanova wrote: On Mon, Jun 7, 2010 at 2:23 AM, Peter Eisentraut pete...@gmx.net wrote: The N'' syntax is in the SQL standard, I didn't know that, do you know what paragraph is it? i can't find it Look for

Re: [HACKERS] nvarchar notation accepted?

2010-06-07 Thread Peter Eisentraut
On sön, 2010-06-06 at 21:13 -0500, Jaime Casanova wrote: On Thu, May 13, 2010 at 11:00 PM, Tom Lane t...@sss.pgh.pa.us wrote: Jaime Casanova ja...@2ndquadrant.com writes: On Thu, May 13, 2010 at 10:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Actually, the lexer translates N'foo' to NCHAR

Re: [HACKERS] nvarchar notation accepted?

2010-06-07 Thread Jaime Casanova
On Mon, Jun 7, 2010 at 2:23 AM, Peter Eisentraut pete...@gmx.net wrote: The N'' syntax is in the SQL standard, I didn't know that, do you know what paragraph is it? i can't find it -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL -- Sent via pgsql-hackers

Re: [HACKERS] nvarchar notation accepted?

2010-06-07 Thread Peter Eisentraut
On mån, 2010-06-07 at 12:56 -0500, Jaime Casanova wrote: On Mon, Jun 7, 2010 at 2:23 AM, Peter Eisentraut pete...@gmx.net wrote: The N'' syntax is in the SQL standard, I didn't know that, do you know what paragraph is it? i can't find it Look for national character string literal. --

Re: [HACKERS] nvarchar notation accepted?

2010-06-06 Thread Jaime Casanova
On Thu, May 13, 2010 at 11:00 PM, Tom Lane t...@sss.pgh.pa.us wrote: Jaime Casanova ja...@2ndquadrant.com writes: On Thu, May 13, 2010 at 10:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Actually, the lexer translates N'foo' to NCHAR 'foo' and then the grammar treats that just like CHAR 'foo'.  In

Re: [HACKERS] nvarchar notation accepted?

2010-05-14 Thread Florian Pflug
On May 14, 2010, at 5:56 , Jaime Casanova wrote: On Thu, May 13, 2010 at 10:13 PM, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Jaime Casanova ja...@2ndquadrant.com wrote: i migrate a ms sql server database to postgres and was trying some queries from the application to find if

Re: [HACKERS] nvarchar notation accepted?

2010-05-13 Thread Takahiro Itagaki
Jaime Casanova ja...@2ndquadrant.com wrote: i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when i was looking to those queries i found some that has a notation for nvarchar (ej: campo = N'sometext') Do you

Re: [HACKERS] nvarchar notation accepted?

2010-05-13 Thread Tom Lane
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes: Jaime Casanova ja...@2ndquadrant.com wrote: i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when i was looking to those queries i found some that has a

Re: [HACKERS] nvarchar notation accepted?

2010-05-13 Thread Jaime Casanova
On Thu, May 13, 2010 at 10:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Actually, the lexer translates N'foo' to NCHAR 'foo' and then the grammar treats that just like CHAR 'foo'.  In short, the N doesn't do anything very useful, and it certainly doesn't have any effect on encoding behavior.  I

Re: [HACKERS] nvarchar notation accepted?

2010-05-13 Thread Tom Lane
Jaime Casanova ja...@2ndquadrant.com writes: On Thu, May 13, 2010 at 10:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Actually, the lexer translates N'foo' to NCHAR 'foo' and then the grammar treats that just like CHAR 'foo'.  In short, the N doesn't do anything very useful, and it certainly

Re: [HACKERS] nvarchar notation accepted?

2010-05-13 Thread Jaime Casanova
On Thu, May 13, 2010 at 10:13 PM, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Jaime Casanova ja...@2ndquadrant.com wrote: i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when i was looking to

Re: [HACKERS] nvarchar notation accepted?

2010-05-13 Thread Peter Eisentraut
On tor, 2010-05-13 at 23:52 -0400, Tom Lane wrote: Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes: Jaime Casanova ja...@2ndquadrant.com wrote: i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when