Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AD23C9FB42F for ; Fri, 20 Apr 2007 16:19:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 69789-08 for ; Fri, 20 Apr 2007 16:19:48 -0300 (ADT) X-Greylist: delayed 00:30:00.491665 by SQLgrey-1.7.4 Received: from mta3.srv.hcvlny.cv.net (mta3.srv.hcvlny.cv.net [167.206.4.198]) by postgresql.org (Postfix) with ESMTP id B34259FB39C for ; Fri, 20 Apr 2007 16:19:50 -0300 (ADT) Received: from [192.168.1.180] (ool-4578656c.dyn.optonline.net [69.120.101.108]) by mta3.srv.hcvlny.cv.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTP id <0JGT000AZ8ASN750@mta3.srv.hcvlny.cv.net> for pgsql-sql@postgresql.org; Fri, 20 Apr 2007 14:49:40 -0400 (EDT) Date: Fri, 20 Apr 2007 14:53:40 -0400 From: Wei Weng Subject: Question on interval To: pgsql-sql@postgresql.org Message-id: <46290C34.9080507@kencast.com> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT User-Agent: Thunderbird 1.5.0.10 (X11/20070221) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/197 X-Sequence-Number: 28197 Hi all. How do I write a query that converts an interger to the interval type? Like convert integer 10 to INTERVAL '10 seconds'? The integer is a column in a table though, so it is more like convert integer tbl.theInteger to INTERVAL 'tbl.theInteger seconds". Thanks! Wei