From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "William Temperley" <willtemperley(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Creating XML/KML documents from single tables |
Date: | 2008-01-02 15:25:37 |
Message-ID: | 162867790801020725o15ec3eag4a4ef4eac24dc8aa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
you have to use xmlagg function
Regards
Pavel Stehule
On 02/01/2008, William Temperley <willtemperley(at)gmail(dot)com> wrote:
> Hi
> I would be most grateful if someone could help me create an xml doc in the form:
>
> <root>
> <layer name = 'x1'>
> <marker id="35"
> class="1"><Point><coordinates>-3.04,53.56,0</coordinates></Point></marker>
> <marker id="35"
> class="4"><Point><coordinates>-2.04,55.56,0</coordinates></Point></marker>
> </layer>
> <layer name = 'x2'>
> <marker id="35"
> class="3"><Point><coordinates>-3.44,57.56,0</coordinates></Point></marker>
> </layer>
> </root>
>
> This will be created from a single table of point geometries where
> each belongs to a layer, e.g. x1 or x2 etc. The layer a geometry
> belongs to is stored in a varchar column called layername.
>
> Creating the marker tags is easily done using the query:
> # select xmlelement(name marker, xmlattributes(gid as id, typeid as
> class), askml(the_geom)) from poi
>
> Or creating a list of layers is also simple:
> #select xmlelement(name layer, xmlattributes(layername as name)) from
> poi group by layername
>
> However I cannot work out how to insert more than one child node into
> a layer element.
>
> Thanks
>
> Will T
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Abraham, Danny | 2008-01-02 15:29:24 | Slow count(*) |
Previous Message | Pavel Stehule | 2008-01-02 15:23:08 | Re: Need help requiring uniqueness in text columns |