Re: function to filter out tokens (sql syntax lexical)?

Поиск
Список
Период
Сортировка
От Wim Bertels
Тема Re: function to filter out tokens (sql syntax lexical)?
Дата
Msg-id 1302854831.18226.18.camel@zwerfkat
обсуждение исходный текст
Ответ на Re: function to filter out tokens (sql syntax lexical)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, 2011-04-14 at 16:53 -0400, Tom Lane wrote:
> Wim Bertels <wim.bertels@khleuven.be> writes:
> > is there a function one could use to filter out the specific tokes?
>
> In 8.4 and up, pg_get_keywords() might help.

indeed something i could use as reference

i'm actually looking for a way to compare two sql statement,
and to check if they are equivalent (not only semantically,
since this usually makes a difference in execution plan).

i suppose the postgresql internal must have some sort of functions
handling this, while parsing the statement.
i would be handy to have this function available as a db user.

tnx,
Wim

>
>             regards, tom lane
>



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: How can you have an Exclusive Lock on nothing? please help me understand this lock monitoring query output
Следующее
От: Shawn Gennaria
Дата:
Сообщение: Migrating Data Across Major Versions