Re: Using function like where clause - Mailing list pgsql-sql

From Ragnar
Subject Re: Using function like where clause
Date
Msg-id 1186510837.5778.403.camel@localhost.localdomain
Whole thread Raw
In response to Using function like where clause  (Ranieri Mazili <ranieri.oliveira@terra.com.br>)
List pgsql-sql
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 instead of a string


> 2) Can I use a function that will return a string to return the list of
> columns that I want to show like below?
>
> select my_function_making_list_of_columns()
> from table
> where field_test = 'mydatum'

no

gnari



pgsql-sql by date:

Previous
From: Ragnar
Date:
Subject: Re: Range of caracters
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Restricting columns by users