select distinct() question

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-novice(at)postgresql(dot)org
Subject: select distinct() question
Date: 2003-04-18 03:49:26
Message-ID: 3E9F75C6.8040100@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message paul butler 2003-04-18 05:28:21 Re: select distinct() question
Previous Message Josh Berkus 2003-04-17 18:39:15 Re: Can I make a function an explicit transaction within?