Using function like where clause

From: Ranieri Mazili <ranieri(dot)oliveira(at)terra(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Using function like where clause
Date: 2007-08-06 19:44:43
Message-ID: 46B77A2B.4090804@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hello,

I have 2 questions.
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'

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'

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keaton Adams 2007-08-06 19:49:17 Re: Template zero xid issue
Previous Message Ranieri Mazili 2007-08-06 19:44:29 Using function like where clause

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2007-08-06 19:57:27 Re: [SQL] Using function like where clause
Previous Message Ranieri Mazili 2007-08-06 19:44:29 Using function like where clause