Received: from sivka.carrier.kiev.ua (sivka.carrier.kiev.ua [193.193.193.101]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56FlPE92535 for ; Wed, 6 Jun 2001 11:47:26 -0400 (EDT) (envelope-from evpopkov@carrier.kiev.ua) Received: from ed.ed (ln2-99.users.lucky.net [193.193.199.99]) by sivka.carrier.kiev.ua (8/Kilkenny_is_better) with ESMTP id SSE90630 for ; Wed, 6 Jun 2001 18:47:14 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: (from root@localhost) by ed.ed (8.8.7/8.8.5) id PAA00485 for pgsql-sql@postgresql.org; Wed, 6 Jun 2001 15:23:57 GMT From: KuroiNeko Date: Wed, 06 Jun 2001 15:23:57 +0000 To: pgsql-sql@postgresql.org Subject: RE: Distinct Values Message-ID: <3B1E4B0D.nailCH11EIRH@ed.ed> References: <819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de> User-Agent: nail 9.14 2000-06-26 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/67 X-Sequence-Number: 3285 > Author URL > ------- -------- > A http://www.xyz http://www.abc .com > - - > B http://www.def http://www.ijk http://www.rst .com > - - > > If that is what you want, you cannot manage it. Sure, in no way this is possible with SQL (in terms of relational DBMS). However, many people find dup'ed values on the `left pane' annoying and that's why report tools exist :) Actually, getting rid of dup's is fairly simple in this exact case if query output is run through a text processing script in PERL or awk. -- ÌĤ¯Ç­¤ÏÁͤòÊá¤é¤Ì