Skip site navigation (1) Skip section navigation (2)

Re: c type of int8 / serial8?

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: J(dot)Kraaijeveld(at)Askesis(dot)nl
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: c type of int8 / serial8?
Date: 2008-08-12 02:50:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Joost Kraaijeveld wrote:
> Hi,
> I wonder what the C type of int8 / serial8 is.
> If I use SQLGetTypeInfo() to get all the supported type is says that
> int8 is of SQL type SQL_BIGINT. It does not show any values for serial8
> but I suppose that that is a user defined type and the driver is not
> required to show those (is that correct?). 

serial8 is bigint not a user defined type.

xxxx=> create table tab1 (id serial8);
NOTICE:  CREATE TABLE will create implicit sequence "tab1_id_seq" for 
serial column ""
xxxx=> insert into tab1 values ('-9223372036854775808');
xxxx=> select * from tab1;
(1 row)

In response to


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2008-08-12 04:04:03
Subject: Re: int2: sql type bug?
Previous:From: Joost KraaijeveldDate: 2008-08-11 20:55:12
Subject: int2: sql type bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group