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
|
| Список | 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.
<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 по дате отправления: