Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-sql by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group