Re: function

From: Ian Turner <vectro(at)pipeline(dot)com>
To: Normunds <normunds(at)mt(dot)lv>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: function
Date: 2000-08-31 01:50:09
Message-ID: Pine.LNX.4.21.0008301849430.955-100000@crafter.house
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> 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.

Probably best to do this as an embedded perl sql function. Then it is
about 3 lines.

Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE5rbnTfn9ub9ZE1xoRAh7uAKCAxqAM9Wo09g6qntF6qJTtp5u+KACgsO9d
VvH5BBpn4gIpdrHFAw8x6Jo=
=zH55
-----END PGP SIGNATURE-----

In response to

  • function at 2000-08-30 15:54:51 from Normunds

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-08-31 02:47:47 Re: initdb Error: 'oid8'
Previous Message andrew 2000-08-31 01:09:03 Re: Large selects handled inefficiently?

Browse pgsql-sql by date

  From Date Subject
Next Message Igor N. Avtaev 2000-08-31 03:45:22 Re: 7.0.2 questions on encoding and compilation
Previous Message Jan Wieck 2000-08-30 22:14:10 Re: function