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"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
