Search Postgresql Archives

Re: replacing single quotes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 some variable
>> in some programming language.
>> Escaping single quotes is only for string literals.
> 
> The input is for an SRF which accepts an array..
> 
> eg:
> select * from foo(date1,date2,'{aaa,bbb,ccc}')
> 
> where the function goes..
> create function foo(timestamp, timestamp, foo_list text[]) 
> returns setof
> ...

Yes, but where does '{aaa,bbb,ccc}' come from?
I assume that this string literal is only an example
that you use to describe how the function is called.

In reality you will have varying values for the
foo_list function argument. So you'll store it in some
kind of variable, right?

In which programming language do you write?

Yours,
Laurenz Albe

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux