Re: Suggestions for implementing IS DISTINCT FROM? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Suggestions for implementing IS DISTINCT FROM?
Date
Msg-id 17512.1024926138@sss.pgh.pa.us
Whole thread Raw
In response to Re: Suggestions for implementing IS DISTINCT FROM?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Rod Taylor
Date:
Subject: Re: pg_dump and ALTER TABLE / ADD FOREIGN KEY
Next
From: "Dave Page"
Date:
Subject: Re: pgadmin.postgresql.org displaying errors