From: | "Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar> |
---|---|
To: | "'Medi Montaseri'" <montaseri(at)gmail(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Data layer migration from MSSQL |
Date: | 2008-02-21 18:55:35 |
Message-ID: | 00cb01c874bb$5a230510$0e690f30$@com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)gmail(dot)com]
Enviado el: jueves, 21 de febrero de 2008 16:43
Para: Sebastian Rychter
CC: pgsql-sql(at)postgresql(dot)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(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 | Robert Treat | 2008-02-22 03:31:57 | Re: Proposed archival read only trigger on rows - prevent history modification |
Previous Message | Medi Montaseri | 2008-02-21 18:42:41 | Re: Data layer migration from MSSQL |