X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FDA0329DB1 for ; Wed, 6 Oct 2004 09:13:49 +0100 (BST) 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 06354-09 for ; Wed, 6 Oct 2004 08:13:35 +0000 (GMT) Received: from sv0.iquer.net (sv0.iquer.net [195.234.230.122]) by svr1.postgresql.org (Postfix) with SMTP id 677CF329D69 for ; Wed, 6 Oct 2004 09:13:35 +0100 (BST) Received: (qmail 23997 invoked by uid 108); 6 Oct 2004 08:13:28 -0000 Received: from unknown (HELO fuzz.int.iquer.net) (10.0.17.20) by sv0.iquer.net with SMTP; 6 Oct 2004 08:13:28 -0000 From: Erik Wasser To: pgsql-sql@postgresql.org Subject: Re: Howto turn an integer into an interval? Date: Wed, 6 Oct 2004 10:13:27 +0200 User-Agent: KMail/1.7 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200410061013.28369.erik.wasser@iquer.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/39 X-Sequence-Number: 19142 On Tuesday 05 October 2004 13:44, you wrote: > If you know for sure that you are keeping resend_interval in seconds, > then try as follows: > > foodb=# SELECT (59::text||' secs')::interval; > interval > ---------- > 00:00:59 > (1 row) Thanks for this solution and the others. It's now working very fine. B-) -- So long... Fuzz