Re: Help with simple query

From: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
To: "Collin Peters" <cadiolis(at)gmail(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Help with simple query
Date: 2005-12-29 01:47:40
Message-ID: CCB89282FCE1024EA3DCE687A96A5164039EC88E@ehost010-6.exch010.intermedia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

or, from the "stupid tricks" category:

SELECT
n.user_id,
max(lpad(extract(epoch from n.modified_date),12,'0') || ' ' || note)
FROM notes n
GROUP by n.user_id

i am not *really* suggesting this!

Browse pgsql-sql by date

  From Date Subject
Next Message George Pavlov 2005-12-29 02:00:59 Re: DISTINCT with NULLs and INT fields
Previous Message PFC 2005-12-29 01:31:50 Re: Help with simple query