Skip site navigation (1) Skip section navigation (2)

Re: [SQL] time precision.

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Anagha Joshi <ajoshi(at)nulinkinc(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>, <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] time precision.
Date: 2003-07-30 09:45:17
Message-ID: 20030730024319.R21395-100000@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
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?



In response to

pgsql-admin by date

Next:From: Dani OderbolzDate: 2003-07-30 10:00:22
Subject: Re: Partition DB Tables by month
Previous:From: Colin 't HartDate: 2003-07-30 09:17:06
Subject: Re: changing ownership of db

pgsql-sql by date

Next:From: A. Van HookDate: 2003-07-30 10:06:02
Subject: now 7.2.3 - 7.3.3
Previous:From: LEONDate: 2003-07-30 09:43:39
Subject: Re: How can I to solute this problem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group