Example stored function generating and returning XML

Lists: pgsql-novice
From: "Tjibbe" <tjibbe(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Example stored function generating and returning XML
Date: 2005-09-22 09:43:02
Message-ID: BAY13-DAV9BC2DE140478805F678E3DD970@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

Hello,

I'm looking for exampels of (PL/pgsql) functions which generatie XML from normal (relational) datatables and returns it in a TEXT type.

Has somebody experience with this?

Greetz

Tjibbe