On Mon, Aug 06, 2007 at 04:44:29PM -0300, Ranieri Mazili wrote:
> 1) Can I use a function that will return a string in a where clause like
> bellow?
> 2) Can I use a function that will return a string to return the list of
> columns that I want to show like below?
not in sql. you can in pl/pgsql
On mán, 2007-08-06 at 16:44 -0300, Ranieri Mazili wrote:
> 1) Can I use a function that will return a string in a where clause like
> bellow?
>
> select *
> from table
> where my_function_making_where()
> and another_field = 'another_think'
you could have your function return a boolean
On Aug 6, 2007, at 14:44 , Ranieri Mazili wrote:
1) Can I use a function that will return a string in a where clause
like bellow?
select *
from table
where my_function_making_where()
and another_field = 'another_think'
Probably. What have you tried? What does the documentation say