Skip site navigation (1) Skip section navigation (2)

grouping of query data in xml

From: c k <shreeseva(dot)learning(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: grouping of query data in xml
Date: 2012-01-21 15:22:34
Message-ID: CAN2Y=uNKurwSBxdEpKDTTORCnfxordBaxc2yaRVn5amtaW-r3w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Hi friends,

I am working with some xml exporting functionality of our application. I am
testing query_to_xml function supported in PostgreSQL 9.1. XML output
should be
 <accgroup>
  <accgroupid>1</accgroupid>
  <accgroupname>COMPANY ACCOUNT</accgroupname>
 <docs>
  <refaccdocid>638168</refaccdocid>
  <debit>10000.0000</debit>
  <credit>0.0000</credit>
 </docs>
 <docs>
 <refaccdocid>638168</refaccdocid>
  <debit>0.0000</debit>
  <credit>10000.0000</credit>
  </docs>
</accgroup>

but the output is as follows:
<row>
  <accgroup>acc group</accgroup>
  <accgroupid>1</accgroupid>
  <accgroupname>COMPANY ACCOUNT</accgroupname>
  <docs>docs</docs>
  <refaccdocid>638168</refaccdocid>
  <debit>10000.0000</debit>
  <credit>0.0000</credit>
</row>

<row>
  <accgroup>acc group</accgroup>
  <accgroupid>1</accgroupid>
  <accgroupname>COMPANY ACCOUNT</accgroupname>
  <docs>docs</docs>
  <refaccdocid>638168</refaccdocid>
  <debit>0.0000</debit>
  <credit>10000.0000</credit>
</row>

How can grouping on specific columns can be done in result xml through
using query_to_xml?
I am expecting help from postgresql community as always.

Thanks

CPKulkarni

Responses

pgsql-admin by date

Next:From: David JohnstonDate: 2012-01-21 15:43:56
Subject: Re: [GENERAL] grouping of query data in xml
Previous:From: Jesper KroghDate: 2012-01-21 06:33:59
Subject: Force explicit transactions on insert / update

pgsql-general by date

Next:From: David JohnstonDate: 2012-01-21 15:43:56
Subject: Re: [GENERAL] grouping of query data in xml
Previous:From: tuanhoanganhDate: 2012-01-21 13:40:55
Subject: Re: PGbouncer for Windows 2008

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group