Re: Date comparison, user defined operators and magic

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Petru Ghita <petrutz(at)venaver(dot)info> writes:
> Hello everybody, I was missing a comparison operator for DATE so I
> wrote one after a really fast look into the documentation.

Huh?

regression=# \do <
                                                 List of operators
   Schema   | Name |        Left arg type        |       Right arg type        | Result type |     Description     
------------+------+-----------------------------+-----------------------------+-------------+---------------------
 ...
 pg_catalog | <    | date                        | date                        | boolean     | less-than
 ...

> So I started to wonder how is this possible because after doing the
> first comparison using the < operator I really wasn't expecting any of
> the other operators to work at all. But they did!

They were all there before.  I doubt it was using yours even in the <
case, because pg_catalog is normally at the front of the search path.

			regards, tom lane