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