Re: [GENERAL] workaround for lack of REPLACE() function

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org, lockhart(at)fourpalms(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: [GENERAL] workaround for lack of REPLACE() function
Date: 2002-08-11 20:09:43
Message-ID: 3D56C487.3060109@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

Tatsuo Ishii wrote:
>>Any objection if I rework this function to meet SQL92 and fix the bug?
> I don't object.

One more question on this: how can I generate some characters with > 1
encoding length? I need a way to test the work I'm doing, and I'm not
quite sure how to test it.

Just making a database that uses a MB encoding doesn't make 0-9/A-Z/a-z
into characters of > 1 byte, does it? Sorry, but never having used MB
encoding has left me a bit clueless on this ;-)

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-08-11 20:10:24 Re: help writing a constraint
Previous Message Gregory Seidman 2002-08-11 19:53:19 help writing a constraint

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-08-11 21:15:47 Domains and Indexes
Previous Message Bruce Momjian 2002-08-11 19:29:51 Re: python patch

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2002-08-11 20:17:08 PGPASSWORDFILE env var for libpq
Previous Message Tom Lane 2002-08-11 19:26:32 Re: CREATE OR REPLACE TRIGGER