On Thu, Jul 03, 2008 at 11:50:39AM +0200, [EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
