Re: [GENERAL] tinterval and timespan

On Mon, Jun 01, 1998 at 03:19:25PM -0500, Jackson, DeJuan wrote:
> > there any examples around?
> try (without the line break):
> select '["Mon Jun 01 15:11:21 1998 EDT" "Mon Jun 08 15:11:21 1998
> EDT"]'::tinterval;

That's a working solution instead of the one psql gives:

tst=> \dd tinterval
Object = tinterval
time interval '(abstime,abstime)'

One problem remains: If I am going to use any of the operators for
tinterval mentioned in the user guide nothing happens except that the
connection to the backend will get lost.

tst=> select range from datum where range #< '2 years';
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.

Werner
--
Werner Reisberger public-key available: voice: +49 234 540294
Schoellmannstr. 20 pgp-public-keys(at)keys(dot)pgp(dot)net Fax: +49 234 540239
D-44807 Bochum with "get 0xED527449" in the subject