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

/contrib/unixdate: Broke in cvs tip.

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: /contrib/unixdate: Broke in cvs tip.
Date: 2001-05-29 10:11:15
Message-ID: 20010529051115.A3774@lerami.lerctr.org (view raw or flat)
Thread:
Lists: pgsql-hackers
I tried to use the unixdate contrib, and got the following:

attack=# \i unixdate.sql
psql:unixdate.sql:21: ERROR:  ProcedureCreate: there is no builtin
function named "-"
psql:unixdate.sql:25: ERROR:  Function 'abstime_datetime(int4)' does
not exist
        Unable to identify a function that satisfies the given
argument types
        You may need to add explicit typecasts
psql:unixdate.sql:29: ERROR:  ProcedureCreate: there is no builtin
function named "-"
psql:unixdate.sql:33: ERROR:  Function 'reltime_timespan(int4)' does
not exist
        Unable to identify a function that satisfies the given
argument types
        You may need to add explicit typecasts
attack=# 


Any ideas? (I need SOMETHING that takes a unix timestamp and turns it
to timestamp. )


Thanks!

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Responses

pgsql-hackers by date

Next:From: D'Arcy J.M. CainDate: 2001-05-29 12:25:24
Subject: Re: AW: User functions and AIX
Previous:From: Zeugswetter Andreas SBDate: 2001-05-29 08:02:02
Subject: AW: Re: charin(), text_char() should return something else for empty input

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