to_date & to_char with postgres 6.5 & 7.0

Started by ochapiteauabout 25 years ago3 messagesgeneral
Jump to latest
#1ochapiteau
ochapiteau@cyberdeck.net

I have a database in production under 6.5 and i need to use the to_date and
to_char function.
I planned to migrate to postgres 7.0 later but i need a compatibility from now
for my projects.

Where do i find the postgres65.sql to install this functions under postgres 65 ?

thanks,
oliver

#2Karel Zak
zakkr@zf.jcu.cz
In reply to: ochapiteau (#1)
Re: to_date & to_char with postgres 6.5 & 7.0

On Wed, Feb 28, 2001 at 10:28:11AM +0100, ochapiteau wrote:

I have a database in production under 6.5 and i need to use the to_date and
to_char function.
I planned to migrate to postgres 7.0 later but i need a compatibility from now
for my projects.

Where do i find the postgres65.sql to install this functions under postgres 65 ?

Not exists for 6.5, it's in 7.0 and later. Go and migrate to postgres 7.0.x
now :-)

Karel

--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

#3ochapiteau
ochapiteau@cyberdeck.net
In reply to: Karel Zak (#2)
Re: to_date & to_char with postgres 6.5 & 7.0

But i've seen in a faq about the postgres65.sql file which add this
functions for postgres 6.5 (and is replaced by an other one in tcl) ?
I can't find this file (not in postgres 6 & 7 src).
I'm i wrong ?
what's postges65.sql ?

Le mer, 28 f�v 2001, vous avez �crit :

On Wed, Feb 28, 2001 at 10:28:11AM +0100, ochapiteau wrote:

I have a database in production under 6.5 and i need to use the to_date and
to_char function.
I planned to migrate to postgres 7.0 later but i need a compatibility from now
for my projects.

Where do i find the postgres65.sql to install this functions under postgres 65 ?

Not exists for 6.5, it's in 7.0 and later. Go and migrate to postgres 7.0.x
now :-)

Karel

--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

-----------------------