X-Original-To: pgsql-sql@postgresql.org
Received: from ms-smtp-02.tampabay.rr.com (ms-smtp-02.tampabay.rr.com
	[65.32.1.39]) by postgresql.org (Postfix) with ESMTP id 9E262475A4B
	for <pgsql-sql@postgresql.org>; Tue, 18 Mar 2003 12:59:32 -0500 (EST)
Received: from [192.168.0.105] (169-52.34-65.tampabay.rr.com [65.34.52.169])
	by ms-smtp-02.tampabay.rr.com (8.12.5/8.12.5) with ESMTP id
	h2IHxVUM010568
	for <pgsql-sql@postgresql.org>; Tue, 18 Mar 2003 12:59:31 -0500 (EST)
Subject: showing records from the last 20 min
From: Matthew Nuzum <cobalt@bearfruit.org>
To: Postgres SQL <pgsql-sql@postgresql.org>
Content-Type: text/plain
Organization: Bearfruit.org
Message-Id: <1048010456.1151.105.camel@localhost.localdomain>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.1 (1.2.1-1) 
Date: 18 Mar 2003 13:00:56 -0500
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200303/442
X-Sequence-Number: 12481

I know this is such a simple question, but I can't find the answer in
the manual and I've tried very hard to find it.

I want to show all the records in a table that occurred in the last 20
min.

So, maybe something like:
select * from sys_logins WHERE tstamp >= now() - '00:20';

on pg 7.3.2 this produces the error:
ERROR:  Bad timestamp external representation '00:20'
 
Thanks for any help,
-- 
Matthew Nuzum
cobalt@bearfruit.org
www.bearfruit.org