| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |