On Thu, Jul 03, 2008 at 11:50:39AM +0200, lbarcala@xxxxxxxxxxxxxxxx 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
