Upgrade 7.2.1 to 7.3.4 datetime Error

From: Eko Pranoto <koprapostgres(at)telkom(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrade 7.2.1 to 7.3.4 datetime Error
Date: 2003-10-01 05:54:50
Message-ID: 200310011254.50537.koprapostgres@telkom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Stainburn 2003-10-01 09:41:22 setting default date format
Previous Message Gaetano Mendola 2003-09-30 23:41:39 News group