Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with simple query - Mailing list pgsql-sql

From George Pavlov
Subject Re: Help with simple query
Date
Msg-id CCB89282FCE1024EA3DCE687A96A5164039EC88E@ehost010-6.exch010.intermedia.net
Whole thread Raw
In response to Help with simple query  (Collin Peters <cadiolis@gmail.com>)
List pgsql-sql
Tree view 
or, from the "stupid tricks" category:
SELECT  n.user_id,   max(lpad(extract(epoch from n.modified_date),12,'0') || ' ' || note)FROM notes nGROUP by n.user_id

i am not *really* suggesting this!

pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: Help with simple query
Next
From: "George Pavlov"
Date:
Subject: Re: DISTINCT with NULLs and INT fields