A question on systable_beginscan()

Поиск
Список
Период
Сортировка
От Onder Kalaci
Тема A question on systable_beginscan()
Дата
Msg-id CAKRSrggiSyCMiQ92RMyF+RmsGOHcsmqN7W3h5z52gJ=_7Bo9dw@mail.gmail.com
обсуждение исходный текст
Ответы Re: A question on systable_beginscan()  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-hackers
Hi hackers,

As it's documented in the source code, systable_beginscan() could be used to on non-system tables as well. My question is that, is it possible to write a C code with systable_beginscan(), systable_getnext() and ScanKeys which is equivalent to the following query: (Assume that the qual_column is a text column)

SELECT id FROM table WHERE qual_column::int = 15;

In other words, can we cast a column type to another type via these low-level APIs? Are there any examples in the Postgres source?

Thanks,
Onder

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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: Move PinBuffer and UnpinBuffer to atomics
Следующее
От: David Steele
Дата:
Сообщение: Re: POC, WIP: OR-clause support for indexes