Re: function calls in WHERE clause

From: "Lee Harr" <missive(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: function calls in WHERE clause
Date: 2004-09-09 21:12:33
Message-ID: BAY2-F9FB36BIY6EOKB0001ad57@hotmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

>... So either I need to just define a totally separate
>this_program_immutable() function or go with my Pl/PgSQL
>wrapper -- which is already written and working well.
>So I guess that is that :o)
>

Installed my plpgsql wrapped view today and the query
that was taking 4 seconds is down to 100msec. What
a nice surprise! Really made my day...

I cannot say enough how much I appreciate all the hard
work that goes in to postgresql. This place is the best.

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2004-09-09 21:30:17 Re: How to determine a database is intact?
Previous Message Oliver Jowett 2004-09-09 21:04:06 Re: [JDBC] ERROR: canceling query due to user request