Upgrade 7.2.1 to 7.3.4 datetime Error - Mailing list pgsql-admin

From Eko Pranoto
Subject Upgrade 7.2.1 to 7.3.4 datetime Error
Date
Msg-id 200310011254.50537.koprapostgres@telkom.net
Whole thread Raw
Responses Re: Upgrade 7.2.1 to 7.3.4 datetime Error  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Upgrade 7.2.1 to 7.3.4 datetime Error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hey folks..
I have problem when upgrade from 7.2.1 to 7.3.4
with function I create...

How I can fix it ?

Thank you for any suggestion
EKo Pranoto


--------------Message Recieve----------------------
ERROR:  Function datetime(timestamp with time zone) does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

-----------------FUNCTION------start-------------
CREATE FUNCTION "set_waktu" ()
RETURNS timestamp without time zone AS 'set datestyle to ''european'';
set datestyle to ''sql'';
select datetime(now()) as result' LANGUAGE 'sql';
---------------FUNCTION--------end-------------



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How can I make PosgreSQL use an Index ?
Next
From: Gary Stainburn
Date:
Subject: setting default date format