From: Sebastian Rychter <srychter@anvet.com.ar>
To: 'Medi Montaseri' <montaseri@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Data layer migration from MSSQL
Date: Thu, 21 Feb 2008 16:55:35 -0200
Message-ID: <00cb01c874bb$5a230510$0e690f30$@com.ar> (raw)
In-Reply-To: <8078a1730802211042y35ea99bend21914ee2e330f00@mail.gmail.com>
References: <008801c874b1$d468cad0$7d3a6070$@com.ar>
<8078a1730802211042y35ea99bend21914ee2e330f00@mail.gmail.com>
Sorry, I think it was misunderstood. I meant that I used the keyword “Order” as a table property, not as part as the statement
In MS SQL I use [Order] and then just query :
Select [Table1].[Order] from [Table1]
Or
Select [Table1].[order] from [Table1]
In Postgresql I can’t do : create table Table1 (order varchar(10)) -- because “order” is a keyword
I have to do it like : create Table1 (“Order” varchar(10))
And then always do the query like : Select “Order” from Table1
which is different from
Select “order” from Table1
Thanks again.
De: Medi Montaseri [mailto:montaseri@gmail.com]
Enviado el: jueves, 21 de febrero de 2008 16:43
Para: Sebastian Rychter
CC: pgsql-sql@postgresql.org
Asunto: Re: [SQL] Data layer migration from MSSQL
I think the grammer should help the parser to determine what you mean when the token ORDER is seen.
for example in a select statement...
Syntax:
SELECT expression [, ...]
...
[ FROM from_item [, ...] ]
[ WHERE condition ]
...
[ ORDER BY expression [ ASC | DESC | USING operator ]
keywords (or reserved words) should not be placed in quotes because the parser relies on them to steer ...
Cheers
Medi
On Thu, Feb 21, 2008 at 9:47 AM, Sebastian Rychter <srychter@anvet.com.ar> wrote:
Hi, I'm working on migrating a data layer from MS SQL Server to PostgreSQL 8.2 and found that some reserved words should only be written between quotes and thus are case sensitive (actually only happened with a table field named "order"). Is there any way to bypass this case sensitivity or at least determine that I am going to use certain reserved words as table fields (or any other possible solutions) ?
Thanks,
Sebastian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: srychter@anvet.com.ar, montaseri@gmail.com
Subject: Re: Data layer migration from MSSQL
In-Reply-To: <00cb01c874bb$5a230510$0e690f30$@com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox