Re: string_to_array, array_to_string function without separator

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: string_to_array, array_to_string function without separator
Date: 2019-03-15 15:46:43
Message-ID: CAFj8pRC-ZrhuJFfwvzGR3=ui7A2avVPffqQQ2h4TLZbt-5ZxaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

pá 15. 3. 2019 v 15:03 odesílatel David Fetter <david(at)fetter(dot)org> napsal:

> On Fri, Mar 15, 2019 at 05:04:02AM +0100, Pavel Stehule wrote:
> > Hi
> >
> > I propose mentioned functions without specified separator. In this case
> the
> > string is transformed to array of chars, in second case, the array of
> chars
> > is transformed back to string.
> >
> > Comments, notes?
>
> Whatever optimizations you have in mind for this, could they also work
> for string_to_array() and array_to_string() when they get an empty
> string handed to them?
>

my idea is use string_to_array('AHOJ') --> {A,H,O,J}

empty input means empty result --> {}

>
> As to naming, some languages use explode/implode.
>

can be, but if we have string_to_array already, I am thinking so it is good
name.

> Best,
> David.
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-03-15 15:49:52 Re: Ordered Partitioned Table Scans
Previous Message Robert Haas 2019-03-15 15:34:17 Re: "WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3