Include result of function call within WHERE clause in results

From: Dallas Morisette <p28flyer(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Include result of function call within WHERE clause in results
Date: 2009-05-17 00:44:42
Message-ID: 1717FB3A-2E7F-4CD4-B15D-5DC24D0A28FD@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all -

I need to select the rows of a table that satisfy a condition that
includes a function call, and I want to include the result of the
function call as a column in the resulting table. For example, this
pseudo-code produces the result I'm looking for:

SELECT field1, some_function(...) FROM my_table
WHERE some_function(...) < some_number

However, I would like to avoid calling the function in two places,
especially since embedded in the parameters to the function I have
another SELECT command. Not to mention it just looks messy...

I've already tried the following without luck:

SELECT field1, some_function(...) AS result FROM my_table
WHERE result < some_number

Is there a way to cache the result of the function call so it can be
used in both places without two separate calls?

Thanks in advance,
Dallas Morisette

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ...tharas 2009-05-17 13:05:56 COUNT() BASED ON MULTIPLE WHERE CONDITIONS
Previous Message Tom Lane 2009-05-16 19:16:03 Re: Custom sorting