Re: C++ -> C : Module for converting the WHERE clause to the canonical form with PostgreSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: C++ -> C : Module for converting the WHERE clause to the canonical form with PostgreSQL
Дата
Msg-id 25252.1137165870@sss.pgh.pa.us
обсуждение исходный текст
Ответ на C++ -> C : Module for converting the WHERE clause to the canonical form with PostgreSQL  ("St Valentine" <valentinest@ukr.net>)
Список pgsql-hackers
"St Valentine" <valentinest@ukr.net> writes:
> That module is writen in the C++ langguage, how can i connect it to
> the PostgreSQL sources?

Convert it to C ;-)  Seriously, I think this would be a major pain in
the neck to do --- there are various gotchas like the system headers not
being C++-clean.  Why don't you just resurrect the qual canonicalization
logic that existed in src/backend/optimizer/prep/prepqual.c not too long
ago?

> In our project we must to compare
> queries. Beacause of the same query can be writen in different forms,
> so to compare queries we must to convert them to the same form of
> presentation.

I find this argument fairly dubious, though, as there are plenty of ways
to write the same query differently.  Forcing the condition into CNF or
DNF will fix only some of them.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: GRANT/REVOKE column-level privileges
Следующее
От: kevin brintnall
Дата:
Сообщение: Re: GRANT/REVOKE column-level privileges