Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Florian Pflug <fgp(at)phlo(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate
Date: 2011-06-19 19:38:28
Message-ID: 4DFE5034.5020304@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 06/19/2011 02:56 PM, Robert Haas wrote:
> On Sun, Jun 19, 2011 at 9:53 AM, Florian Pflug<fgp(at)phlo(dot)org> wrote:
>> Amidst the discussion, Alvaro suggested that we resolve the issue
>> by adding a distinct type for patterns as opposed to text. That'd
>> allow us to make "~" it's own commutator by defining both
>> text ~ pattern
>> and
>> pattern ~ text.
> That's kind of a neat idea. There might be an efficiency benefit to
> having a regex type that is precompiled by the input function.

What do we do when we get text or unknown in place of pattern? How are
we going to know if the pattern is supposed to be the left or right operand?

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-06-19 20:10:20 Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate
Previous Message Dmitriy Igrishin 2011-06-19 19:36:55 Re: Libpq enhancement