Thread: result from where clause

hi

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?

-kjetil

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.