RE: Distinct Values

From: KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua>
To: pgsql-sql(at)postgresql(dot)org
Subject: RE: Distinct Values
Date: 2001-06-06 15:23:57
Message-ID: 3B1E4B0D.nailCH11EIRH@ed.ed
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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.

--

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-06-06 15:41:27 Re: Tutorial : using foreign keys, retrictions etc
Previous Message Dawn 2001-06-06 15:23:21 multiple sql update w/ major time issues