Postgres Pro
Downloads
Home   >   mailing lists

select distinct() question - Mailing list pgsql-novice

From Jean-Christian Imbeault
Subject select distinct() question
Date
Msg-id 3E9F75C6.8040100@mega-bucks.co.jp
Whole thread Raw
Responses Re: select distinct() question  ("paul butler" <paul@entropia.co.uk>)
Re: select distinct() question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
I observed the following for one of my queries:

TEST=# select distinct(prod_id), date_received from invoice_li;
  prod_id | date_received
---------+---------------
    10994 | 2003-04-02
    12445 | 2003-04-08
    12445 |
(3 rows)


Is this the correct behaviour for a select distinct()?

I tried understanding what the SQL standard says but was thoroughly
confused ;)

Jean-Christian Imbeault

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Can I make a function an explicit transaction within?
Next
From: "paul butler"
Date:
Subject: Re: select distinct() question