aliases

Started by ivanover 22 years ago2 messages
#1ivan
iv@psycho.pl

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

now about plpgsql
i think that will be nice , to possible declare var. with names started
from $ (like functions arguments names $1 .. )

and i tkink thet command EXECUTE should exec not SQL command, but plpgsql
command, Its very good way to create somthing like eval .
Then EXECUTE 'SELECT INTO var 4;'; will be not a problem any more.

and what about my functions to ips addreses and ports ???

thx
ivan

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: ivan (#1)
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"