Migrate to Postgres - Alias a Keyword?

Поиск
Список
Период
Сортировка
От Huan Ruan
Тема Migrate to Postgres - Alias a Keyword?
Дата
Msg-id CAD1stZv54cCFmDcYfrzb2ias3qx=seOewRh0=qEKsrdOThtSvQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Migrate to Postgres - Alias a Keyword?
Список pgsql-sql
Hi All

We are migrating from Firebird to Postgres. We try to minimise changes required to the application code which has lots of SQLs in it. One of the incompatibilities between these two is the way to limit the number of rows returned by a SELECT query. 

In Postgres, SELECT * FROM TestTable LIMIT 10
In Firebird,   SELECT * FROM TestTable ROWS 10 

What I'm trying to do here is to get Postgres to accept ROWS as if it's LIMIT. Looks like this is possible by adding an alias in /src/include/parser/kwlist.h, although ROWS is already defined in it for other purpose. 

Does anyone has a suggestion on this? Can I achieve this without recompiling our own copy of Postgres?

Thanks
Huan
   

В списке pgsql-sql по дате отправления:

Предыдущее
От: Ben Morrow
Дата:
Сообщение: Re: Need help revoking access WHERE state = 'deleted'
Следующее
От: Torsten Zuehlsdorff
Дата:
Сообщение: Re: Migrate to Postgres - Alias a Keyword?