Re: Please rename split(text,text,int) to splitpart

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Hannu Krosing" <hannu(at)tm(dot)ee>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Please rename split(text,text,int) to splitpart
Date: 2002-09-11 03:02:17
Message-ID: GNELIHDDFBOCMGBFGEFOKECOCEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

I think it should be made. Don't force an initdb. Beta testers can run the
update. 'split' is a pretty standard function these days...

Chris

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Bruce Momjian
> Sent: Wednesday, 11 September 2002 10:33 AM
> To: Hannu Krosing
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Please rename split(text,text,int) to splitpart
>
>
>
> What do people think if this change?
>
> ------------------------------------------------------------------
> ---------
>
> Hannu Krosing wrote:
> >
> > It seems that my last mail on this did not get through to the list ;(
> >
> >
> >
> > Please consider renaming the new builtin function
> >
> > split(text,text,int)
> >
> > to something else, perhaps
> >
> > split_part(text,text,int)
> >
> > (like date_part)
> >
> > The reason for this request is that 3 most popular scripting languages
> > (perl, python, php) all have also a function with similar signature, but
> > returning an array instead of single element and the (optional) third
> > argument is limit (maximum number of splits to perform)
> >
> > I think that it would be good to have similar function in (some future
> > release of) postgres, but if we now let in a function with same name and
> > arguments but returning a single string instead an array of them, then
> > we will need to invent a new and not so easy to recognise name for the
> > "real" split function.
> >
> > ----------------
> > Hannu
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square,
> Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Curt Sampson 2002-09-11 03:06:31 Re: [JDBC] problem with new autocommit config parameter
Previous Message Stephan Szabo 2002-09-11 02:58:09 Re: problem with new autocommit config parameter and jdbc

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2002-09-11 03:28:38 Re: Please rename split(text,text,int) to splitpart
Previous Message Bruce Momjian 2002-09-11 02:57:32 Re: findoidjoins patch (was Re: [HACKERS] findoidjoins)