| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
| Cc: | David Fetter <david(at)fetter(dot)org>, George Pavlov <gpavlov(at)mynewplace(dot)com>, delux256-postgresql(at)yahoo(dot)com, PostgreSQL GENERAL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question about a query with two count fields |
| Date: | 2007-09-11 19:26:48 |
| Message-ID: | 17264.1189538808@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Michael Glaesemann <grzm(at)seespotcode(dot)net> writes:
> What's ambigious about it? An operator cannot include a space, so !=
> (no space) is *always* interpreted as one operator: not equals (<>).
Right. There are some corner cases though, for example
A*-5
which you'd probably rather weren't interpreted as a single operator
"*-". I believe the hack we use for this involves parsing a trailing
"+" or "-" as a separate operator if the earlier part of the operator
name contains only a certain set of characters. The grotty details
are in the manual ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-09-11 19:44:32 | Re: GRANT on information_schema & keys |
| Previous Message | Michael Glaesemann | 2007-09-11 19:18:29 | Re: Question about a query with two count fields |