Re: Question about a query with two count fields - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about a query with two count fields
Date
Msg-id 17264.1189538808@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about a query with two count fields  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Michael Glaesemann <grzm@seespotcode.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

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Question about a query with two count fields
Next
From: Tom Lane
Date:
Subject: Re: GRANT on information_schema & keys