> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 10 July 2003 13:38
> To: Dave Page
> Subject: Re: [pgadmin-support] Overloading functions that are
> used by operators.
>
>
> Dave Page wrote:
>
> >
> >
> >>-----Original Message-----
> >>From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> >>Sent: 10 July 2003 12:52
> >>To: Dave Page
> >>Cc: Donald Fraser; pgadmin-support@postgresql.org
> >>Subject: Re: [pgadmin-support] Overloading functions that are
> >>used by operators.
> >>
> >>
> >>
> >
> >
> >
> >>It "kind-of" works like this, but the question why the join
> >>won't work
> >>for Donald is still not answered.
> >>I created the same stuff as Donald, and pgadmin works ok.
> >>On my 7.4, po.oid=op.oprcode is evaluated as ::oid=::oid.
> >>Maybe on 7.3
> >>this is done po.oid::regproc::text=op.oprcode::regproc::text, which
> >>could lead to that problem.
> >>
> >>
> >
> >If I create the textcat(bytea, bytea) function Donald suggests, then
> >the original query errors. The new one does not. I don't
> know why, but
> >clearly it is a PostgreSQL issue, not a pgAdmin one as your original
> >query is clearly valid.
> >
> >
> >
> OK, this is clearly a < 7.4 issue, 7.4 doesn't have this
> problem. I do
> have the citext type and operators in my system now.
OK, patch applied. Donald; can you please check it's OK as soon as you
preferred distro has been updated (are you compiling from source? If so,
just grab it from CVS or wait for tonights snapshot).
Regards, Dave.
