hello all, I am new to this list, and I hope my request is well placed, here. I tried searching the archives but I wasn't lucky.
I want to create an index over two columns and one function: the WHERE clause is: WHERE lower(name)=? AND type_id=? AND syn_id=? I know from the docs that I have to create on function that wraps these three values for creating the appropriate index. I have practically no idea how to do this (e.g. what type/set should this function return?). Thanks a lot for pointers to documentation/former postings or any help Cheers Chantal ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster