| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Florian Pflug <fgp(at)phlo(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Boolean operators without commutators vs. ALL/ANY |
| Date: | 2011-06-17 13:36:49 |
| Message-ID: | 1308317770-sup-6340@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Excerpts from Florian Pflug's message of vie jun 17 04:46:32 -0400 2011:
> 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 "~"?
Err, we don't have commutators today?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2011-06-17 13:47:04 | Re: XPATH evaluation |
| Previous Message | Bruce Momjian | 2011-06-17 13:11:19 | Re: pg_upgrade using appname to lock out other users |