From: | Dan S <strd911(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | strange type name in information_schema |
Date: | 2011-05-21 17:59:46 |
Message-ID: | BANLkTikOptb+9+mZ-i90iR4POmUkrk_Z2Q@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi !
I'm running "PostgreSQL 9.0.2, compiled by Visual C++ build 1500, 32-bit".
I'm trying to get type information on functions out of information_schema.
When there is an array as input or output of a function I try to query
information_schema of the array type.
In this case udt_name gives the type name _text why does it not give text ?
Is this the right way to query the parameter types ?
CREATE OR REPLACE FUNCTION test(ta text[]) RETURNS void AS $$
BEGIN
RETURN;
END;
$$ LANGUAGE plpgsql;
select p.udt_name,p.data_type,*
from information_schema.routines r ,information_schema.parameters p
where r.routine_name = 'test'
and p.specific_name = r.specific_name
and p.specific_catalog=r.specific_catalog
and p.specific_schema=r.specific_schema
Best Regards
Dan S
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-05-21 18:04:20 | Re: strange type name in information_schema |
Previous Message | Pavel Stehule | 2011-05-21 17:44:15 | Re: counterintuitive behaviour in pl/pgsql |