Postgres Pro
Downloads
Home   >   mailing lists

CREATE INDEX function limitation - Mailing list pgsql-general

From brichard@cafod.org.uk (Bruce Richardson)
Subject CREATE INDEX function limitation
Date
Msg-id 20010304161449.A3931@usb.cafod.org.uk
Whole thread Raw
Responses Re: CREATE INDEX function limitation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
In a CREATE INDEX statement, functions don't do type conversion and
can't be nested, meaning that the cast convertion function won't work.

So,

CREATE INDEX testidx on testtable (upper(CAST colname AS TEXT));

fails.  Is this a feature I should just work around?

Using 7.0.3-2

--
Bruce

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: triggers vs "NEW" pseudorecord
Next
From: Tom Lane
Date:
Subject: Re: postgres locks...