Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 42B8A2E0084 for ; Mon, 12 May 2008 10:44:31 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97892-06 for ; Mon, 12 May 2008 10:44:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14]) by developer.postgresql.org (Postfix) with ESMTP id 758C52E004A for ; Mon, 12 May 2008 10:44:20 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id 5BF6438E6C4 for ; Mon, 12 May 2008 16:44:17 +0300 (EEST) Received: from [192.168.16.191] (unknown [192.168.16.191]) by nSoft.lt (Postfix) with ESMTP id 2A30CBF302 for ; Mon, 12 May 2008 17:25:58 +0000 (GMT) Message-ID: <482849B0.6050103@nsoft.lt> Date: Mon, 12 May 2008 16:44:16 +0300 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: how to get a number of seconds in some interval ? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.18 tagged_above=0 required=5 tests=AWL=0.180 X-Spam-Level: X-Archive-Number: 200805/90 X-Sequence-Number: 29174 Hello, Is there a good method of knowing how mutch seconds does some interval have?? I tried my_interval / (interval '1 second'), but there is no operator interval / interval defines (I wonder why). Is there a method to do so? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050