Received: from moon.mt.lv (root@moon.mt.lv [159.148.147.194])
	by hub.org (8.10.1/8.10.1) with ESMTP id e7UFuCC93385;
	Wed, 30 Aug 2000 11:56:13 -0400 (EDT)
Received: from normunds (normunds.int.mt.lv [10.5.8.23])
	by moon.mt.lv (8.9.3/8.9.3) with SMTP id RAA25007;
	Wed, 30 Aug 2000 17:59:25 +0200
Message-ID: <078001c0129a$a2354ec0$1708050a@mt.lv>
From: "Normunds" <normunds@mt.lv>
To: <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>
Subject: function
Date: Wed, 30 Aug 2000 17:54:51 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-4"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Archive-Number: 200008/748

Hi all,

how can I write function which takes text from one field, replaces
some characters and puts it in other field? I have array with old and
new values.

For example:
old array = {'r', 'Z', 'o'}
new array = {'s', 'm', 't'}
old field value = 'Zorro'
new field value which must calculate this function = 'mtsst'

This function will be used in update trigger.
Any ideas?

Normunds