Re: Differences in WHERE clause of SELECT - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Differences in WHERE clause of SELECT
Date
Msg-id CAHyXU0z6sPrRDFwtRB6iT+L3TROLfbPOS680KAvjJOH0iD9PCQ@mail.gmail.com
Whole thread Raw
In response to Re: Differences in WHERE clause of SELECT  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Differences in WHERE clause of SELECT
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: refresh materialized view concurrently
Next
From: Markus Wanner
Date:
Subject: Re: Proposal: template-ify (binary) extensions