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

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

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Michael Meskes <meskes(at)topsystem(dot)de>
Cc: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Lost a function overloading capability in v6.3
Date: 1998-03-03 14:33:47
Message-ID: 34FC14CB.16373A2@alumni.caltech.edu (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?

destroydbcreatedb

Oops. Sorry about that. The good news is that the function isn't damaging to
your system :-/

> > 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)

OK, so that is on a v6.3 system Michael? Then does anyone have an idea why
my system is showing a problem? Can someone running on Linux (RH4.2, 2.0.30
kernel) try this out?? _Everything_ in the regression tests is OK...

                                            - Tom


In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-03-03 14:35:09
Subject: Re: [HACKERS] text should be a blob field
Previous:From: Michael MeskesDate: 1998-03-03 14:06:14
Subject: Re: [HACKERS] Current 6.3 issues

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