| From: | "Normunds" <normunds(at)mt(dot)lv> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | function |
| Date: | 2000-08-30 15:54:51 |
| Message-ID: | 078001c0129a$a2354ec0$1708050a@mt.lv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Sears | 2000-08-30 16:00:54 | more large objects |
| Previous Message | Tom Lane | 2000-08-30 14:55:58 | Re: equality operator on CIDR column as primary key |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jie Liang | 2000-08-30 16:22:22 | Re: Optimizing huge inserts/copy's |
| Previous Message | Stephan Szabo | 2000-08-30 14:52:07 | Re: Create Primary Key? |