Re: Caching for stable expressions with constant arguments v6

Marti Raudsepp <marti@juffo.org>

From: Marti Raudsepp <marti@juffo.org>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-10-31T19:04:15Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Refactor simplify_function et al to centralize argument simplification.

On Wed, Oct 31, 2012 at 2:21 AM, Josh Berkus <josh@agliodbs.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