Skip site navigation (1) Skip section navigation (2)

Re: Concatenating several rows with a semicolon

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Concatenating several rows with a semicolon
Date: 2010-12-28 22:23:42
Message-ID: AANLkTintVzTYX5SDvLiXrMZK7wD9-Q=OC2yBaeWbAgbE@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hello Dmitriy,

I think this combination of attributes and children:

>> >> > <user id="bla bla bla ...>
>> >> >  <pref_money date="2010-52" money="760" />
>> >> >  <pref_money date="2010-51" money="3848" />
>> >> >  ... etc ...
>> >> > </user>

will be a good balance between size and my original problem
(combining user data and their stats in 1 chunk of information).

And I don't use JSON, because it is not natively
supported by Flex/Flash and my app is in Flex (here is its pic:
http://stackoverflow.com/questions/4548878/pl-pgsql-concatenating-row-values-to-a-json-like-string
)

>> > Well, generally storing data in attributes should be avoided:

You haven't backuped your statement by any arguments

Regards
Alex

In response to

Responses

pgsql-general by date

Next:From: tmooreDate: 2010-12-28 22:59:28
Subject: Min/Max for partitioned tables
Previous:From: Bill MoranDate: 2010-12-28 22:15:17
Subject: Re: Concatenating several rows with a semicolon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group