Re: result from where clause - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: result from where clause
Date
Msg-id 20041105173500.GA8855@wolff.to
Whole thread Raw
In response to result from where clause  (Kjetil Haaland <kjetil.haaland@student.uib.no>)
List pgsql-novice
On Fri, Nov 05, 2004 at 15:01:44 +0100,
  Kjetil Haaland <kjetil.haaland@student.uib.no> wrote:
> I have a function that returns an integer value. Then i do a select from a
> table and uses this function in the where part of the select. Is it possible
> to get a row with the value from the function when i do the select from the
> table?

Unless you are doing something complicated, you should be able to just
add the function call to the select list.

pgsql-novice by date:

Previous
From: "John-Paul Delaney"
Date:
Subject: Re: Install 7.4.6 on Redhat 8.0 - Any issues?
Next
From: Joe Conway
Date:
Subject: Re: building a row with a plpgsql function