Re: Concatenating several rows with a semicolon

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Re: Concatenating several rows with a semicolon
Дата
Msg-id AANLkTi=Q=x_EgtYhhU0Lca=QV35WcpDWgHnNbx_x2Eeg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Concatenating several rows with a semicolon  (Alexander Farber <alexander.farber@gmail.com>)
Ответы Re: Concatenating several rows with a semicolon  (Alexander Farber <alexander.farber@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: Concatenating several rows with a semicolon
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: Concatenating several rows with a semicolon