From: | bricklen <bricklen(at)gmail(dot)com> |
---|---|
To: | acizov(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8211: Syntax error when creating index on expression |
Date: | 2013-06-05 16:33:54 |
Message-ID: | CAGrpgQ86K8k_aO+PNGjGj-SOnyuuK-yQ46Fk9u7g1mp+HKWa9Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Jun 5, 2013 at 8:24 AM, <acizov(at)gmail(dot)com> wrote:
>
> Bug reference: 8211
> Logged by: Andrey Cizov
> Email address: acizov(at)gmail(dot)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
Did you look at the docs?
http://www.postgresql.org/docs/current/static/sql-createindex.html
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-06-05 16:35:06 | Re: BUG #8211: Syntax error when creating index on expression |
Previous Message | geoff.montee | 2013-06-05 16:07:02 | BUG #8212: Feature request: View original value of current_user in function with SECURITY DEFINER set |