Re: Concatenating several rows with a semicolon

[Dmitriy Igrishin <dmitigr@xxxxxxxxx>]

2010/12/29 Alexander Farber <alexander.farber@xxxxxxxxx>

On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin <dmitigr@xxxxxxxxx> wrote:
>> > <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.

Attributes give me smaller size...

Well, JSON might give you smaller size. Why you need XML then? :-)

Regards

Alex

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

-- 
// Dmitriy.