Creating XML/KML documents from single tables

Поиск
Список
Период
Сортировка
От William Temperley
Тема Creating XML/KML documents from single tables
Дата
Msg-id 439dc11e0801020617y66308f75g2f0a661bea960f52@mail.gmail.com
обсуждение исходный текст
Ответы Re: Creating XML/KML documents from single tables  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Fwd: [ADMIN] Shutting down warm standby server? "
Следующее
От: Matthew Wilson
Дата:
Сообщение: Re: Need help requiring uniqueness in text columns