Postgres Pro
Downloads
Home   >   mailing lists

Thread: Fw: Overloading functions that are used by operators.

Fw: Overloading functions that are used by operators.

From
"Donald Fraser"
Date:
Whoops did it again - used the reply again without changing the to:
 
----- Original Message -----
Sent: Tuesday, July 08, 2003 9:26 PM
Subject: Re: [pgadmin-support] Overloading functions that are used by operators.

Hi Dave,
if you want an easy way to reproduce it do the following:
 
CREATE FUNCTION pg_catalog.textcat(varchar, text) RETURNS text AS 'textcat' LANGUAGE 'internal' IMMUTABLE STRICT;
This wouldn't normally be necessary as we have type casting that will handle it and or operators but anyway that's beside the point...
 
Either the above statement is illegal or you have to find a different method for locating the function name associated with an operator.
That's the crux of the matter.
 
Regards
Donald Fraser.
----- Original Message -----
From: Dave Page
Sent: Tuesday, July 08, 2003 9:12 PM
Subject: RE: [pgadmin-support] Overloading functions that are used by operators.

 
-----Original Message-----
From: Donald Fraser [mailto:demolish@cwgsy.net]
Sent: 08 July 2003 21:00
To: [ADMIN]
Cc: [pgADMIN]
Subject: [pgadmin-support] Overloading functions that are used by operators.

I have a question regarding operators which are causing problems with the new pgAdmin III software being developed and my database.
The problem has been discussed in depth with the pgAdmin III development team and they have not been able to resolve the issue and suggested that I have either done something that I shouldn't have of or that there is a possible bug with postgresql. 
 
Where was it discussed in depth? The last I heard was that Andreas was going to look into it.
 
I will see if I can reproduce the problem myself.
 
Regards, Dave.