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 example provided:
CREATE INDEX ON films ((lower(title)));
could be written as:
CREATE INDEX ON films (lower(title));
The example expression has yet one additional pair of "()" that are not
required per the syntax since lower(...) is a function call. Extra "()"
never hurt I suppose...
I don't see this come up too often on the list but I will agree that it is
unexpected to require the extra set of "()". An example using an actual
expression with the extra "()" and then the function call example without -
to explicitly show when/why they can be omitted in the examples as well as
in the text - is an idea worth considering.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8211-Syntax-error-when-creating-index-on-expression-tp5758030p5758040.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.