Re: Concatenating several rows with a semicolon

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Concatenating several rows with a semicolon
Date: 2010-12-28 22:14:32
Message-ID: AANLkTikNo8DWe4HG-bGK1rxUioqLv2ycDwWKo5+ay7Vn@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/12/29 Alexander Farber <alexander(dot)farber(at)gmail(dot)com>

> 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...
>
Well, JSON might give you smaller size. Why you need XML then? :-)

>
> Regards
> Alex
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2010-12-28 22:15:17 Re: Concatenating several rows with a semicolon
Previous Message Alexander Farber 2010-12-28 22:07:17 Re: Concatenating several rows with a semicolon