Re: aliases

On Sun, Jul 06, 2003 at 10:15:37PM +0200, ivan wrote:
>
> where can i find aliases to type , for example INT4 = INT = INTEGER ...
> I realy need it to check if function is exists ..
> Or how to get oid from same type , but no like select from pg_type

Maybe this is helpful:

alvh=> select 'int'::regtype;
regtype
---------
integer
(1 row)

alvh=> select 'int4'::regtype;
regtype
---------
integer
(1 row)

alvh=> select 23::regtype;
regtype
---------
integer
(1 row)

I don't know about the rest though.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No renuncies a nada. No te aferres a nada"