Re: Date comparison, user defined operators and magic

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