Postgres Pro
Downloads
Home   >   mailing lists

Re: Selecting exactly one row for each column value - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: Selecting exactly one row for each column value
Date
Msg-id 20070306151719.GC24007@a-kretschmer.de
Whole thread Raw
In response to Selecting exactly one row for each column value  (Florian Weimer <fweimer@bfk.de>)
List pgsql-sql
Tree view 
am  Tue, dem 06.03.2007, um 16:03:36 +0100 mailte Florian Weimer folgendes:
> Is there a better way to implement this?

DISTINCT ON() 

http://www.postgresql.org/docs/current/static/sql-select.html#SQL-DISTINCT


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-sql by date:

Previous
From: Florian Weimer
Date:
Subject: Selecting exactly one row for each column value
Next
From: "Radhika Sambamurti"
Date:
Subject: [Fwd: View Vs. Table]