Postgres Pro
Downloads
Home   >   mailing lists

Re: determining a type oid from the name - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: determining a type oid from the name
Date
Msg-id 4F44E0BC0200002500045A28@gw.wicourts.gov
Whole thread Raw
In response to Re: determining a type oid from the name  (Thom Brown <thom@linux.com>)
Responses Re: determining a type oid from the name  (Thom Brown <thom@linux.com>)
List pgsql-hackers
Tree view 
Thom Brown <thom@linux.com> wrote:
> Does this help?
> 
> test=# SELECT pg_typeof('4834.34'::numeric)::oid;
>  pg_typeof
> -----------
>       1700
> (1 row)
Wouldn't it be easier to do this instead?
test=# SELECT 'numeric'::regtype::oid;oid  
------1700
(1 row)
-Kevin

pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: determining a type oid from the name
Next
From: Thom Brown
Date:
Subject: Re: determining a type oid from the name