From: | trisuresh(at)yahoo(dot)co(dot)in (Suresh Tri) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Overloading || ( text,text ) operator |
Date: | 2004-09-03 13:49:47 |
Message-ID: | a8de98e.0409030549.78dbcba1@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I was trying to overload concat operator ||(text,text) such a way that
it behaves like Oracle. i.e. I want 'abc' || null to return 'abc'
instead of null.
I know that it is not the expected behaviour in postgres, but since I
am migrating the database from oracle to postgres , I need this
behaviour.
But when I try to drop the existing || operator, I get the following
error
ERROR: cannot drop operator ||(text,text) because it is required by
the database system
Also I cannot modify the application which runs over the database.
Hence I cannot overload || (varchar,varchar) and use it.
Is there any way of overloading the || operator , such that it behaves
like Oracle? ( I know that Oracle behaviour is wrong , but my aim is
to move an existing application which runs on Oracle to Postgres :-(
)
Thanks,
Abhiman
From | Date | Subject | |
---|---|---|---|
Next Message | Barry S | 2004-09-03 14:02:52 | Re: Gentoo for production DB server? |
Previous Message | Jeff Amiel | 2004-09-03 12:41:30 | Re: postgres "on in the internet" |