Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Lost a function overloading capability in v6.3

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Michael MeskesDate: 1998-03-03 14:06:14
Subject: Re: [HACKERS] Current 6.3 issues
Previous:From: Thomas G. LockhartDate: 1998-03-03 13:54:34
Subject: Lost a function overloading capability in v6.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group