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
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. ... |