On Thu, Jul 03, 2008 at 11:50:39AM +0200, lbarcala(at)freeresearch(dot)org wrote:
> test=# CREATE INDEX token_position_func
> test-# ON token (position+1);
> ERROR: syntax error at or near "+"
> LINE 2: ON token (position+1);
>
> I read that I can do "ON function(column)" but, is there a built-in
> function in PostgreSQL to do what I want (add one to the value) or have i
> to build one to make this simple calculation?
You just want an extra set of brackets; i.e.:
CREATE INDEX token_position_func ON token ((position+1));
Should do the trick. Not entirely sure why, but it'll probably have
something to do with avoiding ambiguity in the grammar.
Sam