Override system-defined cast?

From: Peter <peter(at)greatnowhere(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Override system-defined cast?
Date: 2006-10-12 09:18:48
Message-ID: 452E0878.7060503@greatnowhere.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way I can override system-defined casts?

Tried

create cast (varchar as timestamptz) with function
user_timestamptz(varchar) ;

and got

ERROR: cast from type pg_catalog.varchar to type timestamptz already exists

DROP CAST does not work:

ERROR: cannot drop cast from character varying to timestamp with time
zone because it is required by the database system

(or are my permissions insufficient?)

Basically my problem is converting '' (empty string) to
NULL::timestampz, and built-in cast cannot convert blank string to
timestamptz. Maybe I'm wondering up the wrong alley with casts?

One solution I can see is create user-defined type (which would be the
same timestamptz) and define varchar->mytype cast, but that will require
rather extensive changes to database schema. Plus, our user-interface
currently relies on PG datatypes to format input/output data.

Any suggestions?

TIA,
Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-10-12 09:47:16 Re: STABLE functions
Previous Message Dawid Kuroczko 2006-10-12 09:14:26 Re: more anti-postgresql FUD