Re: Differences in WHERE clause of SELECT

On Tue, Jul 16, 2013 at 12:58 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> PostgreSQL requires more casts that any other mainstream database
> system on the planet, and it's one of the biggest barriers to
> migrating from other database systems to PostgreSQL.  I understand
> that there is a consensus in this forum to pretend that our
> intolerance is a virtue, but I don't agree with that consensus. A
> request for =(text,int) is ambiguous; we really do not know what is
> meant.  A request for ~~(int,text) is not ambiguous; we reject it out
> of pedantry, not necessity.

You make some good points but I still wonder (I'm recalling your lpad
discussion from a while back) if we're better off providing specific
overloads and casts for portability pain points instead of changing
casting mechanics.

merlin