Re: Suggestions for implementing IS DISTINCT FROM?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Suggestions for implementing IS DISTINCT FROM?
Дата
Msg-id 17512.1024926138@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Suggestions for implementing IS DISTINCT FROM?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Should I use a boolean in the node to indicate whether it is SYMMETRIC or
> ASYMMETRIC, or should I use some sort of integer to indicate whether it is
> SYMMETRIC, ASYMMETRIC or DEFAULT (ASYMMETRIC).  That way the reverse in
> rules and views could leave out the ASYMMETRIC if it wasn't specified
> originally, rather than always adding it in.  Which is better?

My intention is to reverse-list as either "BETWEEN" or "BETWEEN SYMMETRIC".
While I believe in reproducing the source text during reverse listing,
I don't take it to extremes ;-)

So a boolean is sufficient.
        regards, tom lane




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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: pg_dump and ALTER TABLE / ADD FOREIGN KEY
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: pgadmin.postgresql.org displaying errors