From: | "Hartwig Jens" <Jens(dot)Hartwig(at)t-systems(dot)de> |
---|---|
To: | "Nicolas" <bnk(at)medialife(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | RE: Distinct Values |
Date: | 2001-06-06 06:43:20 |
Message-ID: | 819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello Nicolas,
the query you want to construct cannot work because the result of a
query always consists of a consistent table. That means that in a
two-column-table every item on the "left side" has one single opponent
on "the right side". How should your table be built up at all?
I suppose that you want something like the following:
Author URL
------- --------
A http://www.xyz.com
http://www.abc.com
- -
B http://www.def.com
http://www.ijk.com
http://www.rst.com
- -
If that is what you want, you cannot manage it.
Hope this helps ... although it does not really help you :-)
Best regards, Jens Hartwig
-----------------------------------------------------
T-Systems
Project Manager
debis Systemhaus GEI GmbH
Address: Eichhornstraße 3, 10785 Berlin
Postal Address: 10785 Berlin
Phone: (004930) 25 54-32 82
Fax: (004930) 25 54-31 87
Mobile: (0170) 167 26 48
E-Mail: jens(dot)hartwig(at)t-systems(dot)de
Internet: http://www.t-systems.de
> -----Ursprüngliche Nachricht-----
> Von: Nicolas [mailto:bnk(at)medialife(dot)net]
> Gesendet: Mittwoch, 30. Mai 2001 20:23
> An: pgsql-sql(at)postgresql(dot)org
> Betreff: [SQL] Distinct Values
>
>
> Hi,
>
> I'm trying to retreive DISTINCT Values from a two colomn table called
> "Books". The colomns are named "Author" and "URL".
> DISTINCT values should be retieved from the "Author" Colomn ,
> and then I
> should be able to retrieve the corresponding URL.
> How do I build the SQL Query ?
> I tried to use: "SELECT DISTINCT Author FROM Books" But this
> does not allow
> me to fetch the URL value on the other colomn.
>
> Thanks
> Nicolas
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | David BOURIAUD | 2001-06-06 06:43:42 | How to use the type int2vector ? |
Previous Message | Judd Maltin | 2001-06-06 00:05:09 | "Day" from 8am to 3am |