I am receiving the following errors on creating an index using lower() on a
varchar field
db1=> create index fieldindexlower on table1(lower(fieldvalue) varchar_ops);
ERROR: BuildFuncTupleDesc: function 'lower(varchar)' does not exist
Do I need to convert the field to "text" or are there othe
Hello, I am in need of help with performance of case insensitive queries.
I have searched the general and hackers archives for references to this
problem and
have found the information on how to build a lower case index.
I have included output from 3 query plans that detail my performance
proble
Couldn't you restrict access to the table
and create views such as
CREATE VIEW BillsCustomerID001 AS
SELECT * FROM Bills WHERE CustomerID=001
CREATE VIEW BillsCustomerID002 AS
SELECT * FROM Bills WHERE CustomerID=002
etc.
and give Customer 001 access to BillsCustomerID001
give Cust