| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dani Oderbolz | 2003-07-30 10:00:22 | Re: Partition DB Tables by month |
| Previous Message | Colin 't Hart | 2003-07-30 09:17:06 | Re: changing ownership of db |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Van Hook | 2003-07-30 10:06:02 | now 7.2.3 - 7.3.3 |
| Previous Message | LEON | 2003-07-30 09:43:39 | Re: How can I to solute this problem? |