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
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 |