Re: aliases - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: aliases
Date
Msg-id 20030706214226.GA28540@dcc.uchile.cl
Whole thread Raw
In response to aliases  (ivan <iv@psycho.pl>)
List pgsql-hackers
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"


pgsql-hackers by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: Receiving data in binary format how is it encoded?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: How to submit Tsearch V2 ?