Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 18 Apr 2003 12:49:26 +0900
- Message-id: <3E9F75C6.8040100@mega-bucks.co.jp> <text/plain>
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
- Follow-Ups:
- Re: select distinct() question
- From: Tom Lane
- Re: select distinct() question
- From: paul butler
- Re: select distinct() question
- Prev by Date: Re: Can I make a function an explicit transaction within?
- Next by Date: Re: select distinct() question
- Previous by thread: Using array in Functions plpgsql
- Next by thread: Re: select distinct() question
- Indexes: