Skip site navigation (1) Skip section navigation (2)

PGA3 Operator Question

From: efesar <efesar(at)nmia(dot)com>
To: Pgadmin-Hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: PGA3 Operator Question
Date: 2003-04-03 00:52:28
Message-ID: NGBBKFMOILMAGDABPFEGEEIJEBAA.efesar@nmia.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

-Keith


pgadmin-hackers by date

Next:From: frank_lupoDate: 2003-04-03 07:03:39
Subject: problem compilation pgadmin2
Previous:From: efesarDate: 2003-04-02 18:49:38
Subject: Re: pgadmin3 query tools

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group