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: 48A0FA8F.2080903@tpf.co.jp (view raw or flat)
Thread:
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?). 

No.
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 "tab1.id"
CREATE TABLE
xxxx=> insert into tab1 values ('-9223372036854775808');
INSERT 0 1
xxxx=> select * from tab1;
           id
----------------------
  -9223372036854775808
(1 row)


In response to

Responses

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-2014 The PostgreSQL Global Development Group