Re: Caching for stable expressions with constant arguments v6

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Caching for stable expressions with constant arguments v6
Date: 2012-10-31 19:04:15
Message-ID: CABRT9RB+=5=5BQjxAfbz--1UVnv5j4z2iHSCvatx9yes4BJaAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 31, 2012 at 2:21 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> Hey, are you going to work on this for 9.3?

Yes, I do plan to get back to it. Thanks for the push :)

> I really could use the feature ...

If you're not aware already, you can work around the limitation using
a subquery.

Instead of: WHERE foo_column > expensive_expression()
Write: WHERE foo_column > (SELECT expensive_expression())

Regards,
Marti

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2012-10-31 19:35:36 Re: foreign key locks
Previous Message Palle Girgensohn 2012-10-31 18:20:54 alter table tablename add column - breaks pl/pgsql function returns tablename