CREATE INDEX function limitation

From: brichard(at)cafod(dot)org(dot)uk (Bruce Richardson)
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE INDEX function limitation
Date: 2001-03-04 16:14:49
Message-ID: 20010304161449.A3931@usb.cafod.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-04 16:39:14 Re: postgres locks...
Previous Message Louis-David Mitterrand 2001-03-04 12:22:04 Re: Trigger sending an eMail