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 | | [EMAIL PROTECTED] | -----------------------------------------------------------------------------
