Postgres Pro
Downloads
Home   >   mailing lists

BUG #8211: Syntax error when creating index on expression - Mailing list pgsql-bugs

From acizov@gmail.com
Subject BUG #8211: Syntax error when creating index on expression
Date
Msg-id E1UkFZc-0001It-KC@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8211: Syntax error when creating index on expression
Re: BUG #8211: Syntax error when creating index on expression
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      8211
Logged by:          Andrey Cizov
Email address:      acizov@gmail.com
PostgreSQL version: 9.2.3
Operating system:   Windows
Description:        =


CREATE INDEX heuristic ON foos (1 / (a + b))

causes: =


ERROR:  syntax error at or near "1"
LINE 1: CREATE INDEX heuristic ON foos (1 / (a + b))
                                        ^

********** Error **********

ERROR: syntax error at or near "1"
SQL state: 42601
Character: 33

While:

CREATE INDEX heuristic ON foos ((1 / (a + b)))

Execution successful

pgsql-bugs by date:

Previous
From: martin.schaefer@cadcorp.com
Date:
Subject: BUG #8210: UTF8 column names corrupted by server
Next
From: bricklen
Date:
Subject: Re: BUG #8211: Syntax error when creating index on expression