don't know whether nodes of type 719 are equal

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: don't know whether nodes of type 719 are equal
Date: 1999-10-17 19:44:32
Message-ID: Pine.LNX.4.10.9910170044450.3563-100000@peter-e.yi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

... yeah, me neither.

Hi all, I have an interesting one for you today. I'm writing a new \dd
command (one that actually works), and I have come across the following
situation:

SELECT DISTINCT a.aggname as "Name" FROM pg_aggregate a
UNION ALL
SELECT DISTINCT p.proname as "Name" FROM pg_proc p
UNION ALL
SELECT DISTINCT o.oprname as "Name" FROM pg_operator o
UNION ALL
SELECT DISTINCT t.typname as "Name" FROM pg_type t
UNION ALL
SELECT DISTINCT c.relname as "Name" FROM pg_class c
;

(It doesn't make much sense as it stands, but I have picked out the
offending parts.)

I get
NOTICE: equal: don't know whether nodes of type 719 are equal

Actually, I get several of these. Depending on the number of select
clauses, I get 1 for the third, 2 for the 4th, 3 for the 5th, etc. So the
above query gives me 6 notices. A query with only two select clauses gives
me none.

Without the DISTINCTs everything goes fine.

Now this seems to have something to do with a lack of an equal operator
for the type "name", right? Interestingly enough, the type name has oid
19, whereas type 719 is "_circle", or what does the 719 refer to?

Thanks,
Peter

--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-10-17 19:57:52 Re: [HACKERS] don't know whether nodes of type 719 are equal
Previous Message Bruce Momjian 1999-10-17 17:25:00 Re: [HACKERS] is it possible to use LIMIT and INTERSECT ?