X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2AE0ED1B540 for ; Fri, 3 Oct 2003 07:50:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 91478-06 for ; Fri, 3 Oct 2003 04:49:35 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 5CF4AD1B51E for ; Fri, 3 Oct 2003 04:49:33 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h937nWQh051442 for ; Fri, 3 Oct 2003 07:49:32 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h937PH9d048802 for pgsql-sql@postgresql.org; Fri, 3 Oct 2003 07:25:17 GMT From: "Jan Pips" X-Newsgroups: comp.databases.postgresql.sql Subject: Data type conversion Date: Fri, 3 Oct 2003 09:23:46 +0200 Organization: Aster City Net Lines: 7 Message-ID: X-Complaints-To: abuse@astercity.net X-Tech-Contact: usenet@astercity.net X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Newsreader: Microsoft Outlook Express 5.50.4927.1200 X-Server-Info: http://www.astercity.net/news/ X-MSMail-Priority: Normal To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME, RCVD_IN_OSIRUSOFT_COM X-Spam-Level: * X-Archive-Number: 200310/50 X-Sequence-Number: 15450 How to convert the interval type into integer, float or any "countable" data type at the time of table creation using select ... into? Pips