> -----Original Message----- > From: efesar [mailto:[EMAIL PROTECTED] > Sent: 03 April 2003 01:52 > To: Pgadmin-Hackers > Subject: [pgadmin-hackers] PGA3 Operator Question > > > Dave et al, > > * This is a temporary solution until the cache is built. > > I need to get a list of operators from the database that will > return only booleans types, not integer types. This is > basically a list of possible "join" operators. > > This is the query I've found works the best. Do namespaces > matter here? Can anybody suggest a better query? > > SELECT DISTINCT > a.oprname > FROM > pg_operator a > JOIN > pg_type b on ( a.oprresult = b.oid ) > WHERE > a.oprkind = 'b' and b.typname = 'bool' > ORDER BY > a.oprname
Hi Keith, Namespaces do matter because unless the opr is in the search path then it won't be found, and even then, if there are 2 in different schemas then the search path will determine which is to be used unless they are qualified (ie. OPERATOR(pg_catalog.+) ). Query looks OK at a cursory examination. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
