From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de> |
Cc: | "Donald Fraser" <demolish(at)cwgsy(dot)net>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Overloading functions that are used by operators. |
Date: | 2003-07-10 12:07:11 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B844B293@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de]
> Sent: 10 July 2003 12:52
> To: Dave Page
> Cc: Donald Fraser; pgadmin-support(at)postgresql(dot)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.
Regards, Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-10 15:37:51 | Re: [ADMIN] Overloading functions that are used by operators. |
Previous Message | Andreas Pflug | 2003-07-10 11:52:23 | Re: Overloading functions that are used by operators. |