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@keys.pgp.net         Fax: +49 234 540239
D-44807 Bochum      with "get 0xED527449" in the subject