Re: Differences in WHERE clause of SELECT

From: Greg Stark <stark(at)mit(dot)edu>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Differences in WHERE clause of SELECT
Date: 2013-07-16 16:54:59
Message-ID: CAM-w4HPVXVpfmjgSiG4=QfLuQuvPaAw6b-noDRZwjitRK5AnDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 16, 2013 at 4:40 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> But '1' LIKE 1 is not ambiguous

What about '1' LIKE 01 ?

What do people who write this actually expect LIKE to do? I gather
they're actually treating it as a synonym for =?

--
greg

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-07-16 17:02:47 pgsql: Allow background workers to be started dynamically.
Previous Message Ants Aasma 2013-07-16 16:46:20 Re: Improvement of checkpoint IO scheduler for stable transaction responses