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

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate
Дата
Msg-id 4DFE5034.5020304@dunslane.net
обсуждение исходный текст
Ответ на Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

On 06/19/2011 02:56 PM, Robert Haas wrote:
> On Sun, Jun 19, 2011 at 9:53 AM, Florian Pflug<fgp@phlo.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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: Libpq enhancement
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate