From: | wr(at)tribe(dot)ping(dot)de |
---|---|
To: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] tinterval and timespan |
Date: | 1998-06-02 13:24:33 |
Message-ID: | 19980602152433.54051@tribe.ping.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Linden | 1998-06-02 14:29:06 | Loading PDF fiel held on Databases |
Previous Message | Przemyslaw Bak | 1998-06-02 12:57:31 | Resetting connection ... |