Re: LIKE IN

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: David Wheeler <david(at)kineticode(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: LIKE IN
Date: 2004-03-02 05:41:30
Message-ID: 200403012141.30983.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

David,

> So is this perhaps a bug? I mean, LIKE is certainly an operator, not a
> function.

No, it's not a bug. IN is a special merge operator. ANY and ALL are
relational calculus operators, and = is limited to subselects returning a
single value. So they're all "special cases".

I think it would be possible to implement a "value LIKE ( 'x%','y%','z%')" in
postgreSQL but you'd have to get someone interested in hacking it.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • LIKE IN at 2004-03-02 05:04:12 from David Wheeler

Responses

  • Re: LIKE IN at 2004-03-02 05:53:39 from David Wheeler

Browse sfpug by date

  From Date Subject
Next Message David Wheeler 2004-03-02 05:53:39 Re: LIKE IN
Previous Message David Wheeler 2004-03-02 05:04:12 LIKE IN