On Fri, Apr 23, 2004 at 11:46:52AM +0300, Alexei Chetroi wrote:
Date: Fri, 23 Apr 2004 11:46:52 +0300
From: Alexei Chetroi [EMAIL PROTECTED]
User-Agent: Mutt/1.5.5.1+cvs20040105i
To: [EMAIL PROTECTED]
Subject: [SQL] converting unix seconds to timestamp
Hi,
I wish to convert unix
On Sat, Sep 06, 2003 at 01:21:36PM -0400, Rod Taylor wrote:
I'd like to write a query which returns following information regarding
each item: item, date of very first event, very last event.
Is this possible? I think I can write several SELECT queries and
procces them by an application
On Sun, Sep 07, 2003 at 09:09:35AM -0400, Rod Taylor wrote:
[skip]
Thanks everybody for responses. I'm trying this one, but psql complains
on queries like SELECT min(date), event FROM events GROUP BY item that
events must be GROUPed or used in an aggregate function. Why this
Hi All,
I need a little help regarding writing some subqueries. For example I
have a table items which contains columns: itemid, description; and
another table events with columns: itemid, date, event. events.itemid
references items.itemid. Table events contains events regarding some
itemid's