pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hartwig Jens <Jens.Hartwig@t-systems.de>
To: Nicolas <bnk@medialife.net>
To: pgsql-sql@postgresql.org
Subject: RE: Distinct Values
Date: Wed, 6 Jun 2001 08:43:20 +0200
Message-ID: <819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de> (raw)

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.hartwig@t-systems.de
Internet: http://www.t-systems.de 

> -----Ursprüngliche Nachricht-----
> Von: Nicolas [mailto:bnk@medialife.net]
> Gesendet: Mittwoch, 30. Mai 2001 20:23
> An: pgsql-sql@postgresql.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@postgresql.org)
> 



view thread (6+ messages)  latest in thread

Message-ID: <819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de>
Permalink:  ../819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de/
Also on:    postgresql.org/message-id/819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Jens.Hartwig@t-systems.de, bnk@medialife.net
  Subject: RE: Distinct Values
  In-Reply-To: <819FEEAC94E6DC459F1FDC83C0C1611F1D7D6C@mail2000.b3.dsh.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox