From: Medi Montaseri <montaseri@gmail.com>
To: Sebastian Rychter <srychter@anvet.com.ar>
Cc: pgsql-sql@postgresql.org
Subject: Re: Data layer migration from MSSQL
Date: Thu, 21 Feb 2008 10:42:41 -0800
Message-ID: <8078a1730802211042y35ea99bend21914ee2e330f00@mail.gmail.com> (raw)
In-Reply-To: <008801c874b1$d468cad0$7d3a6070$@com.ar>
References: <008801c874b1$d468cad0$7d3a6070$@com.ar>
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: montaseri@gmail.com, srychter@anvet.com.ar
Subject: Re: Data layer migration from MSSQL
In-Reply-To: <8078a1730802211042y35ea99bend21914ee2e330f00@mail.gmail.com>
* 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