>>> On Tue, Aug 14, 2007 at 8:48 AM, in message <b1a365afcf3059983eecc3db74a3cadf@xxxxxxxxxxxx>, <giuseppe.derossi@xxxxxxxx> wrote: > I was studying a solution which foresees the 'case when' construct... > now I can use it in addition to array_to_string . In fact my solution > failed too if <it's raining cats and dogs :-) >, but if there are some more > values I get them all as well. Is there a timestamp, date, or sequence number that you can use to break ties? Without something like that, I don't think you can do what you want with set-based logic -- you would need to do something procedural without any guarantee that you'd get the same results in two different runs. -Kevin ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq