Re: Concatenating several rows with a semicolon

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

> Hello Bill and others,
>
> I don't agree about yw being a bad thing
> since I have weekly raings in my app,
> but your XML suggestion -
>
> On Tue, Dec 28, 2010 at 9:29 PM, Bill Moran <wmoran(at)potentialtech(dot)com>
> wrote:
> >
> > If there are multiple entries for pref_money, then each one should be
> > a container inside user, i.e.:
> >
> > <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.

>
> is a very good point, thanks!
>
> 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.