hi Ligia,
there was a posting to this list some time ago, about the same question.
I just found it as I had the same question as you:
http://archives.postgresql.org/pgsql-sql/1998-05/msg00091.php
(in short: it is not possible in Postgres)
the mail is from 1998, but I just tried to make a sele
hello all,
in my program I have to check for a certain combination of data before I
make an insert. The check is a select statement with a join and a
function call. Now, I wonder if I could gain performance if I would
create a temporary view that contained this join and the function call
and
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
