Ow Mun Heng wrote:
> Input is of form
>
> 'ppp','aaa','bbb'
>
> I want it to be stripped of quotes to become
>
> ppp,aaa,bbb
>>>
>>> The input is for an SRF which accepts an array..
>>>
>>> where the function goes..
>>> create function foo(timestamp, timestamp, foo
On Wed, 2007-10-10 at 10:46 +0200, Albe Laurenz wrote:
> Ow Mun Heng wrote:
> >>> Input is of form
> >>>
> >>> 'ppp','aaa','bbb'
> >>>
> >>> I want it to be stripped of quotes to become
> >>>
> >>> ppp,aaa,bbb
> >>
> >> I'm a little confused that you think that you will have to
> >> escape sin
Ow Mun Heng wrote:
>>> Input is of form
>>>
>>> 'ppp','aaa','bbb'
>>>
>>> I want it to be stripped of quotes to become
>>>
>>> ppp,aaa,bbb
>>
>> I'm a little confused that you think that you will have to
>> escape single quotes in the input.
>> What is your use case? Normally the input is in s
On Wed, 2007-10-10 at 09:11 +0200, Albe Laurenz wrote:
> Ow Mun Heng wrote:
> > Input is of form
> >
> > 'ppp','aaa','bbb'
> >
> > I want it to be stripped of quotes to become
> >
> > ppp,aaa,bbb
> >
> > escaping the quote would work but it means I will have
> > to do some magic on the input a
Ow Mun Heng wrote:
> Input is of form
>
> 'ppp','aaa','bbb'
>
> I want it to be stripped of quotes to become
>
> ppp,aaa,bbb
>
> escaping the quote would work but it means I will have
> to do some magic on the input as well to escape it prior
> to replacing it.
>
> select replace('AB\'A','\''
Input is of form
'ppp','aaa','bbb'
I want it to be stripped of quotes to become
ppp,aaa,bbb
escaping the quote would work but it means I will have to do some magic
on the input as well to escape it prior to replacing it.
select replace('AB\'A','\'','C') this works
Can I buy a clue here?
oh
