Re: workaround for lack of REPLACE() function

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Agent155 Support <matt(at)planetnet(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: workaround for lack of REPLACE() function
Date: 2002-07-11 17:38:17
Message-ID: 3D2DC289.889FBB90@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

...
> I think Thomas did just recently commit the SQL99 OVERLAY function, but
> similar to Tom's comment, I don't like the way SQL99 defines it. I've
> written a replace() C function (along with a couple of other string
> manipulation functions) for my own use. If you'd like a copy let me know
> and I'll gladly send it to you.

OK, what don't you like about it? If you can define some functionality
that we *should* have, then it is likely to go into the main distro.
Either as an extension to existing functions or as a separate function.

"Style" counts for not-much, but "can't do it with what we have" counts
for a lot.

- Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-07-11 17:40:35 Re: Type TEXT
Previous Message chris.gamble 2002-07-11 17:31:34 Case Sensitivity and Indexes

Browse pgsql-hackers by date

  From Date Subject
Next Message Luis Alberto Amigo Navarro 2002-07-11 17:40:46 Re: [HACKERS] please help on query
Previous Message Manfred Koizar 2002-07-11 16:47:03 Re: [HACKERS] please help on query

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2002-07-11 18:34:04 Re: workaround for lack of REPLACE() function
Previous Message Joe Conway 2002-07-11 16:44:34 Re: workaround for lack of REPLACE() function