Re: Functional index adding one

by stark@[EMAIL PROTECTED] (Gregory Stark) Jul 3, 2008 at 03:21 PM

"Gregory Stark" <stark@[EMAIL PROTECTED]
> writes:

> CREATE INDEX token_position_func on (token(position+1))

Ooops, I misread that as if "token" were a function and not the table. Sam
Mason had the right syntax. Sorry.


-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's Slony Replication sup****t!

-- 
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