Postgres Pro
Downloads
Home   >   mailing lists

Re: Concatenating several rows with a semicolon - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: Concatenating several rows with a semicolon
Date
Msg-id AANLkTikNo8DWe4HG-bGK1rxUioqLv2ycDwWKo5+ay7Vn@mail.gmail.com
Whole thread Raw
In response to Re: Concatenating several rows with a semicolon  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Concatenating several rows with a semicolon  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view


2010/12/29 Alexander Farber <alexander.farber@gmail.com>
On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin <dmitigr@gmail.com> wrote:
>> > <user id="bla bla bla ...>
>> >  <pref_money date="2010-52" money="760" />
>> >  <pref_money date="2010-51" money="3848" />
>> >  ... etc ...
>> > </user>
>
> Well, generally storing data in attributes should be avoided:
>
> <user id="id">
>   <pref_money>
>     <date>...</date>
>     <money>...</money>
>   </pref_money>
>   ...
> </user>
> is a better.

Attributes give me smaller size...
Well, JSON might give you smaller size. Why you need XML then? :-)

Regards
Alex

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
// Dmitriy.


pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Concatenating several rows with a semicolon
Next
From: Bill Moran
Date:
Subject: Re: Concatenating several rows with a semicolon