Re: Data layer migration from MSSQL - Mailing list 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.

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