bricklen wrote
> expression
>
> An expression based on one or more columns of the table. The expression
> usually must be written with surrounding parentheses, as shown in the
> syntax. However, the parentheses can be omitted if the expression has the
> form of a function call.
So in fact the exa
aci...@gmail.com writes:
> CREATE INDEX heuristic ON foos (1 / (a + b))
> causes:
> ERROR: syntax error at or near "1"
This is not a bug. You need an extra pair of parentheses around
the expression, ie
CREATE INDEX heuristic ON foos ((1 / (a + b)))
http://www.postgresql.org/docs/9.2/static/sq
On Wed, Jun 5, 2013 at 8:24 AM, wrote:
>
> Bug reference: 8211
> Logged by: Andrey Cizov
> Email address: aci...@gmail.com
> PostgreSQL version: 9.2.3
> Operating system: Windows
> Description:
>
> CREATE INDEX heuristic ON foos (1 / (a + b))
>
> causes:
>
> ERROR: syntax err
The following bug has been logged on the website:
Bug reference: 8211
Logged by: Andrey Cizov
Email address: aci...@gmail.com
PostgreSQL version: 9.2.3
Operating system: Windows
Description:
CREATE INDEX heuristic ON foos (1 / (a + b))
causes:
ERROR: syntax error
