X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8CAFCDB9B9 for ; Thu, 17 Nov 2005 19:18:15 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81799-02 for ; Thu, 17 Nov 2005 23:18:15 +0000 (GMT) X-Greylist: delayed 00:17:11.76197 by SQLgrey- Received: from vhost6.atomicservers.com (vhost6.atomicservers.com [216.58.160.194]) by svr1.postgresql.org (Postfix) with ESMTP id 867F0DB9B3 for ; Thu, 17 Nov 2005 19:18:10 -0400 (AST) Received: from dev11dt.corp.localmatters.com ([64.78.237.253]) (authenticated (0 bits)) by vhost6.atomicservers.com (8.11.6/8.11.6) with ESMTP id jAHNICd26946 for ; Thu, 17 Nov 2005 16:18:12 -0700 Subject: timestamp SQL question From: Brian Doyle To: pgsql-sql@postgresql.org Content-Type: text/plain Date: Thu, 17 Nov 2005 16:18:12 -0700 Message-Id: <1132269492.30942.20.camel@dev11dt.corp.localmatters.com> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/135 X-Sequence-Number: 23386 I have a table like: events visitor_uid varchar(32) event_type varchar(32) event_type timestamp I would like to select events from the table that are older than 30 days from right now. How would I do that in one query? Thanks.