On May 21, 2008, at 7:36 PM, finecur wrote:
select * from my_flexible_sql_function('select * from employee where
dep ='Eng'')
You need to escape that string like 'select * from employee where dep
=''Eng'' '
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and
On Wed, May 21, 2008 at 11:36 AM, finecur <[EMAIL PROTECTED]> wrote:
> Hi, I have a function and it's interface is :
>
>my_flexible_sql_function(cmd)
>
> where cmd is another sql command. I call this function like this:
>
> select * from my_flexible_sql_function('select * from employee where
>
Hi, I have a function and it's interface is :
my_flexible_sql_function(cmd)
where cmd is another sql command. I call this function like this:
select * from my_flexible_sql_function('select * from employee where
id < 100')
Inside this functioin, I will first retrieve all data by calling
'se
