From: | Michael Meskes <meskes(at)topsystem(dot)de> |
---|---|
To: | lockhart(at)alumni(dot)caltech(dot)edu (Thomas G(dot) Lockhart) |
Cc: | pgsql-hackers(at)postgresql(dot)org (PostgreSQL Hacker) |
Subject: | Re: [HACKERS] Lost a function overloading capability in v6.3 |
Date: | 1998-03-03 14:03:17 |
Message-ID: | 199803031403.PAA17641@gauss.topsystem.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas G. Lockhart writes:
> CREATE FUNCTION abstime_datetime(int4)
> RETURNS datetime
> AS '-' LANGUAGE 'internal';
Did that. Could anyone please tell me how to drop this function?
> When I run this same thing on v6.3, I get a date sometime in 1974 which
> I think might actually be derived from a pointer interpreted as an
> integer :(
>
> postgres=> select abstime_datetime(0);
> abstime_datetime
> ----------------------------
> Wed Apr 24 18:51:28 1974 GMT
> (1 row)
> postgres=> select abstime_datetime(900000000);
> abstime_datetime
> ----------------------------
> Wed Apr 24 18:37:12 1974 GMT
> (1 row)
mm=> select abstime_datetime(0);
abstime_datetime
----------------
epoch
(1 row)
mm=> select abstime_datetime(900000000);
abstime_datetime
----------------
epoch
(1 row)
Michael
--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 1998-03-03 14:06:14 | Re: [HACKERS] Current 6.3 issues |
Previous Message | Thomas G. Lockhart | 1998-03-03 13:54:34 | Lost a function overloading capability in v6.3 |