From ajoshi@nulinkinc.com Wed Jul 30 07:54:01 2003 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id EDA95D1C4F1; Wed, 30 Jul 2003 07:54:01 +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 43450-01; Wed, 30 Jul 2003 04:53:00 -0300 (ADT) Received: from TactiCom-MA1.TactiCom.com (unknown [216.235.244.20]) by svr1.postgresql.org (Postfix) with SMTP id B1389D1C4D6; Wed, 30 Jul 2003 04:53:58 -0300 (ADT) Received: from [203.124.133.194] by TactiCom-MA1.Nulinkinc.com (NTMail 4.30.0013/NU4135.00.d4f82e0c) with ESMTP id fkfpiaaa for ; Wed, 30 Jul 2003 03:53:33 -0400 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3566F.76D9A250" Subject: time precision. X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Date: Wed, 30 Jul 2003 13:22:03 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: time precision. Thread-Index: AcNWbxYdLbznW8JHEdedugBABabtaA== From: "Anagha Joshi" To: , X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=4.8 tagged_above=0.0 required=5.0 tests=HTML_80_90, RCVD_IN_DSBL X-Spam-Level: **** X-Archive-Number: 200307/316 X-Sequence-Number: 9656 This is a multi-part message in MIME format. ------_=_NextPart_001_01C3566F.76D9A250 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, I'm using PG-7.2.4 on Solaries. When I do: =20 template1=3D# select time(6576); ERROR: TIME(6576) precision must be between 0 and 13 =20 Where am I wrong? Pls. help =20 Thanks, Anagha ------_=_NextPart_001_01C3566F.76D9A250 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All,

I=92m using PG-7.2.4 on Solaries.

When I do:

template1=3D# select time(657= 6);

ERROR:=A0 TIME(6576) precision must be between 0 and 13

Where am I wrong?

Pls. help

Thanks,

Anagha

=00 ------_=_NextPart_001_01C3566F.76D9A250-- From ch@rodos.fzk.de Wed Jul 30 09:09:02 2003 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 807B7D1C4EC for ; Wed, 30 Jul 2003 09:09:02 +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 45791-05 for ; Wed, 30 Jul 2003 06:08:02 -0300 (ADT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 7F882D1C955 for ; Wed, 30 Jul 2003 06:08:59 -0300 (ADT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Wed Jul 30 11:09:00 2003 +0200 Received: śby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id LAA26612; Wed, 30 Jul 2003 11:08:59 +0200 (METDST) Message-ID: <3F278B2A.CA8001D5@rodos.fzk.de> Date: Wed, 30 Jul 2003 11:08:58 +0200 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org, ajoshi@nulinkinc.com Subject: Re: time precision. Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char 9C hex) in message header 'Received' Received: \234by rodos.fzk.de... ^ X-Archive-Number: 200307/447 X-Sequence-Number: 14561 > I'm using PG-7.2.4 on Solaries. > When I do: > > template1# select time(6576); > ERROR: TIME(6576) precision must be between 0 and 13 > > Where am I wrong? What's the purpose of this function? And where did you find it in the docs? I didn't see it before. Regards, Christoph From sszabo@megazone.bigpanda.com Wed Jul 30 09:45:20 2003 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 75819D1DB3D; Wed, 30 Jul 2003 09:45: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 44649-08; Wed, 30 Jul 2003 06:44:20 -0300 (ADT) Received: from megazone.bigpanda.com (unknown [66.180.233.26]) by svr1.postgresql.org (Postfix) with ESMTP id 1D9EBD1DB2D; Wed, 30 Jul 2003 06:45:18 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 77A95D60F; Wed, 30 Jul 2003 02:45:17 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 654A85C0D; Wed, 30 Jul 2003 02:45:17 -0700 (PDT) Date: Wed, 30 Jul 2003 02:45:17 -0700 (PDT) From: Stephan Szabo To: Anagha Joshi Cc: , Subject: Re: [SQL] time precision. In-Reply-To: Message-ID: <20030730024319.R21395-100000@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/318 X-Sequence-Number: 9658 On Wed, 30 Jul 2003, Anagha Joshi wrote: > Hi All, > I'm using PG-7.2.4 on Solaries. > When I do: > > template1=# select time(6576); > ERROR: TIME(6576) precision must be between 0 and 13 > > Where am I wrong? IIRC time(n) refers to the type time with a precision of n and n is limited as stated by the error. What are you trying to do?