Thanks for the suggestion, 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. thanks --------- Original Message -------- Da: Ben Kim <bkim@xxxxxxxx> To: Cc: pgsql-admin@xxxxxxxxxxxxxx Oggetto: Re: merge two rows where value are null Data: 14/08/07 15:38 > > > > On Tue, 14 Aug 2007, giuseppe.derossi@xxxxxxxx wrote: > > > Name, Surname , Job, Hobby, Pet, address > > John, Smith, NULL, photo, NULL, NULL > > John, Smith, student, NULL, cat, NULL > > > by using name and surname as selecting key, I want : > > > > John, Smith, student, photo, cat, NULL > > If you are sure there's no conflict (multiple values) for a (name, > surname) key, one simple solution might be (surely not an efficient one) > > select > (select distinct Name from thetable where Name = 'name1' and Surname = 'surname1' where Name is not null), > (select distinct Surname from thetable where Name = 'name1' and Surname = 'surname1' where Surname is not null), > (select distinct Job from thetable where Name = 'name1' and Surname = 'surname1' where Job is not null), > (select distinct Hobby from thetable where Name = 'name1' and Surname = 'surname1' where Hobby is not null), > (select distinct Pet from thetable where Name = 'name1' and Surname = 'surname1' where Pet is not null), > (select distinct address from thetable where Name = 'name1' and Surname = 'surname1' where address is not null) > > This will fail if you also have > John, Smith, student, NULL, dog, NULL > > in addition to > > John, Smith, student, NULL, cat, NULL > > You can test for offending rows by: > > select > array_to_string( array( select distinct Pet from thetable where Name = 'name1' and Surname = 'surname1' where Pet is not null),',') > > and so on... > > > Regards, > > Ben K. > Developer > http://benix.tamu.edu > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > > -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Hai bisogno di contanti per realizzare i tuoi desideri? Prometeo ti propone prestiti da 1.500 a 31.000 Euro! Clicca qui per un preventivo immediato. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6916&d=20070814 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
