Re: Concatenating several rows with a semicolon

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Concatenating several rows with a semicolon
Date: 2010-12-28 22:07:17
Message-ID: AANLkTikY51+tNPk8iSGQ172uvRmuFR8RuwFZntxHmGJe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin <dmitigr(at)gmail(dot)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...

Regards
Alex

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-12-28 22:14:32 Re: Concatenating several rows with a semicolon
Previous Message Dmitriy Igrishin 2010-12-28 21:31:15 Re: Concatenating several rows with a semicolon