Hi,
I just tried to create a functional index on a varchar column, which
failed, cos lower() is not defined on varchars. I guess it's only
supported for text columns (aren't they treated the same way internally?).
So, I figured, let's cast the varchar to a text type:
create index product_artit_idx2 on product (lower(artit::text) text_ops);
ERROR: parser: parse error at or near "::"
How can I do this? Isn't there a simple fix to some system table that
tells postgres that using lower() on varchar is OK?
Maarten
_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M.Boekhold@et.tudelft.nl |
-----------------------------------------------------------------------------