2010/12/29 Alexander Farber <alexander.farber@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
// Dmitriy.
