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 AANLkTi=Q=x_EgtYhhU0Lca=QV35WcpDWgHnNbx_x2Eeg@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


2010/12/29 Alexander Farber <alexander.farber@gmail.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@potentialtech.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@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: Alexander Farber
Date:
Subject: Re: Concatenating several rows with a semicolon