phpPgAdmin query help

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: phpPgAdmin query help
Date: 2001-12-11 03:12:01
Message-ID: GNELIHDDFBOCMGBFGEFOGELFCAAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi guys,

I'm fixing the function editor in phpPgAdmin, however there's a problem. We
use this query to return a list of all the possible function return types:

SELECT typname
FROM pg_type pt
WHERE typname NOT LIKE '\\\_%' AND typname NOT LIKE 'pg\\\_%'
EXCEPT
SELECT relname
FROM pg_class
WHERE relkind = 'S'
ORDER BY typname;

Part of this result is this:

bit
bool
box
...
text
tid
time
timestamp
timetz
tinterval
transactions_log

Now the problem is that if you have a function with a defined return type of
'boolean' or 'timestamp with time zone' or 'timestamp without time zone',
how on earth do you match it to something in this list? Alternatively, how
do I query in all the _alias_ types?

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-12-11 03:20:23 Re: Intermediate report for AIX 5L port
Previous Message Thomas Lockhart 2001-12-11 02:47:09 Re: pgsql/doc/src/sgml Makefile cvs.sgml datatype. ...