Thank You,
That's what I need. I know it was something simple but... Now it works perfectly.
Thank's again.
Kaloyan Iliev
Michael Fuhr wrote:
On Wed, Jan 12, 2005 at 10:11:21AM -0700, Michael Fuhr wrote:
On Wed, Jan 12, 2005 at 06:38:51PM +0200, Kaloyan Iliev Iliev wrote:
My problem is that I want to select the row with max(date) but also limited with where clauses.If you don't mind using a non-standard feature then try SELECT
DISTINCT ON (not just DISTINCT, but DISTINCT ON):
Sorry, I probably didn't read your message closely enough. If you just want a single record then ORDER BY ... LIMIT 1 might be more appropriate.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
