Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Functional ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 7 Topic 15965 of 17437
Post > Topic >>

Re: Functional index adding one

by sam@[EMAIL PROTECTED] (Sam Mason) Jul 3, 2008 at 02:19 PM

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




 7 Posts in Topic:
Functional index adding one
lbarcala@[EMAIL PROTECTED  2008-07-03 11:50:39 
Re: Functional index adding one
andreas.kretschmer@[EMAIL  2008-07-03 12:11:20 
Re: Functional index adding one
sam@[EMAIL PROTECTED] (S  2008-07-03 14:19:49 
Re: Functional index adding one
tgl@[EMAIL PROTECTED] (T  2008-07-03 11:11:26 
Re: Functional index adding one
sam@[EMAIL PROTECTED] (S  2008-07-03 17:00:31 
Re: Functional index adding one
stark@[EMAIL PROTECTED]   2008-07-03 14:37:18 
Re: Functional index adding one
stark@[EMAIL PROTECTED]   2008-07-03 15:21:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:59:32 CST 2008.