phpPgAdmin query help
От | Christopher Kings-Lynne |
---|---|
Тема | phpPgAdmin query help |
Дата | |
Msg-id | GNELIHDDFBOCMGBFGEFOGELFCAAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответы |
Re: phpPgAdmin query help
|
Список | 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
В списке pgsql-hackers по дате отправления: