Re: [HACKERS] getting type name

2006-07-10 Thread Martijn van Oosterhout
On Mon, Jul 10, 2006 at 02:03:11AM +0300, Tzahi Fadida wrote: > On Monday 10 July 2006 00:29, Martijn van Oosterhout wrote: > > On Sun, Jul 09, 2006 at 10:08:42PM +0300, Tzahi Fadida wrote: > > > They return format_type_be(INT4OID) = "integer" or > > > format_type_be(FLOAT8OID) = "double precision"

Re: [HACKERS] getting type name

2006-07-09 Thread Tzahi Fadida
On Monday 10 July 2006 00:29, Martijn van Oosterhout wrote: > On Sun, Jul 09, 2006 at 10:08:42PM +0300, Tzahi Fadida wrote: > > They return format_type_be(INT4OID) = "integer" or > > format_type_be(FLOAT8OID) = "double precision" > > I need to use this in a query with the "::" cast operator. > > Th

Re: [HACKERS] getting type name

2006-07-09 Thread Martijn van Oosterhout
On Sun, Jul 09, 2006 at 10:08:42PM +0300, Tzahi Fadida wrote: > They return format_type_be(INT4OID) = "integer" or format_type_be(FLOAT8OID) > = "double precision" > I need to use this in a query with the "::" cast operator. The problem being? test=# select '1'::integer, '4.5'::double precision;

Re: [HACKERS] getting type name

2006-07-09 Thread Tzahi Fadida
On Sunday 09 July 2006 21:49, Michael Fuhr wrote: > On Sun, Jul 09, 2006 at 09:03:21PM +0300, Tzahi Fadida wrote: > > How do i get a char * type from a type Oid. i.e. > > getStringTypeFromOid(INT4OID) will return "int4". > > Server-side or client-side? In the backend I think you could use Backend

Re: [HACKERS] getting type name

2006-07-09 Thread Michael Fuhr
On Sun, Jul 09, 2006 at 09:03:21PM +0300, Tzahi Fadida wrote: > How do i get a char * type from a type Oid. i.e. > getStringTypeFromOid(INT4OID) > will return "int4". Server-side or client-side? In the backend I think you could use format_type_be() or format_type_with_typemod(), both declared i

[HACKERS] getting type name

2006-07-09 Thread Tzahi Fadida
Hi, How do i get a char * type from a type Oid. i.e. getStringTypeFromOid(INT4OID) will return "int4". 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS:  see at http://members.lycos.co.uk/my2nis/spamwarning