From: | Michael Reifenberger <root(at)nihil(dot)plaut(dot)de> |
---|---|
To: | PostgreSQL Hackers <hackers(at)postgreSQL(dot)org> |
Subject: | Timespan_div misbehaving? |
Date: | 1999-03-08 08:33:05 |
Message-ID: | Pine.BSF.4.05.9903080926020.20224-100000@nihil.plaut.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
When I try on current:
abr=> select sum(endt-begt-pausen)/count(*)::float8 from tage;
ERROR: Unable to identify an operator '/' for types 'timespan' and 'float8'
You will have to retype this query using an explicit cast
but:
abr=> \df
...
timespan |timespan_div |timespan float8 |divide
...
Why? Directly used I get:
abr=> select timespan_div(sum(endt-begt-pausen),count(*)::float8) from tage;
timespan_div
-----------------------------
@ 11 hours 24 mins 34.79 secs
(1 row)
It seems that an entry for '/' is defined:
grep timespan_div catalog/*.bki*
...
catalog/local1_template1.bki.source:insert OID = 1585 ( "/" PGUID 0 b t f 1186
1186 1186 0 0 0 0 timespan_div - - )
...
OR are the three 1186's wrong?
Shouldn't at least the second input type be 701?
Any clues?
Bye!
----
Michael Reifenberger
Plaut Software GmbH, R/3 Basis
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-03-08 08:38:16 | Re: [HACKERS] Updatable views? |
Previous Message | Michael Reifenberger | 1999-03-08 07:57:56 |