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

Re: [PATCHES] Intervals within information_schema

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] Intervals within information_schema
Date: 2006-08-25 10:17:55
Message-ID: 4f44b7a867749dfbc8420f032143c6cc@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


>> Does anyone know what is supposed to go into the interval_type field?

> INTERVAL_TYPE IN
> ( 'YEAR', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'SECOND',
>   'YEAR TO MONTH', 'DAY TO HOUR', 'DAY TO MINUTE',
>   'DAY TO SECOND', 'HOUR TO MINUTE',
>   'HOUR TO SECOND', 'MINUTE TO SECOND' )
>
> Also, depending on which one of these is specified, the precision field
> varies in meaning.  I haven't done a complete analysis, but it might
> not be as simple as your patch suggests.

Yes, I saw some docs that hinted as much. I'm still not clear on exactly
what interval_type is supposed to represent, or at least how it would ever
apply to a Postgres attribute. It almost seems as though the spec is calling
for interval_type of 'HOURS' and interval_precision of '2' for an example
interval of '2 hours'? I'd normally say that we should leave it as NULL in
such a case, but someone added a "FIXME" at some point, which led me to
ask exactly what should go in there. Not a big deal, I suppose - it looks
as though few, if any, other products are using those fields either.
Thanks for the reply.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200608250614
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFE7s26vJuQZxSWSsgRAjFZAJ9SNXevNWtN0HXCK9D0FPsYN/9FTQCfeDX8
srbrlp4kO3co/bKPmCjP+q8=
=YaXx
-----END PGP SIGNATURE-----



In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2006-08-25 10:29:14
Subject: Re: RV: Problem at install / uninstall postgresql
Previous:From: Peter EisentrautDate: 2006-08-25 09:30:46
Subject: Re: Autovacuum on by default?

pgsql-patches by date

Next:From: Tom LaneDate: 2006-08-25 12:53:07
Subject: Re: Performance testing of COPY (SELECT) TO
Previous:From: Böszörményi ZoltánDate: 2006-08-25 07:31:42
Subject: Performance testing of COPY (SELECT) TO

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