From: | "Medi Montaseri" <montaseri(at)gmail(dot)com> |
---|---|
To: | "Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Data layer migration from MSSQL |
Date: | 2008-02-21 18:42:41 |
Message-ID: | 8078a1730802211042y35ea99bend21914ee2e330f00@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)anvet(dot)com(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastian Rychter | 2008-02-21 18:55:35 | Re: Data layer migration from MSSQL |
Previous Message | Sebastian Rychter | 2008-02-21 17:47:26 | Data layer migration from MSSQL |