Re: Boolean operators without commutators vs. ALL/ANY - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: Boolean operators without commutators vs. ALL/ANY
Date
Msg-id 98AE71D2-E52D-4F99-A446-9E04181BD907@phlo.org
Whole thread Raw
In response to Re: Boolean operators without commutators vs. ALL/ANY  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Boolean operators without commutators vs. ALL/ANY
List pgsql-hackers
On Jun17, 2011, at 03:42 , Alvaro Herrera wrote:
> To make matters worse, our delimiters for regexes are the same as for
> strings, the single quote.  So you get
> 
> foo =~ 'bar'    /* foo is the text column, bar is the regex */
> 'bar' =~ foo    /* no complaint but it's wrong */
> 
> 'bar' ~= foo    /* okay */
> 'foo' ~= bar    /* no complaint but it's wrong */
> 
> How do I tell which is the regex here?  If we used, say, /, that would
> be a different matter:

How is this different from the situation today where the operator
is just "~"?

best regards,
Florian Pflug




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe