| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | pg novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Unflatten array |
| Date: | 2007-11-02 18:49:14 |
| Message-ID: | 472B712A.8050007@mail.nih.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I am using xpath queries against an XML column like so:
annodb=# select id,xpath('//LastName/text()',content) from medlinexml
limit 10;
id | xpath
----------+----------------------------
12236137 | {Mikulicz-radecki,Freund}
12305346 | {Ota}
12332250 | {Bernstein}
12255346 | {Novak}
12255369 | {Kurzrok}
12332284 | {Davis}
12332297 | {Allen,Pratt,Newell,Bland}
12305416 | {Goldstein}
12305417 | {Seibels}
12305424 | {Richardson}
(10 rows)
I would like to build a view where each id is associated with a text
representation of each last name. So, the view would look like:
12236137 | Mikulicz-radecki
12236137 | Freund
12305436 | Ota
And so on. Is there a way to do this without a pl/pgsql loop?
Thanks,
Sean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | G. J. Walsh | 2007-11-03 00:13:18 | Uncertain about recoding prepared statements from MySQL to PostgreSQL |
| Previous Message | Alan Hodgson | 2007-11-02 18:39:28 | Re: need some help with an opennms query/insert |