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

BUG #2790: constructor for int2vector seems to be buggy

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2790: constructor for int2vector seems to be buggy
Date: 2006-11-28 12:27:43
Message-ID: 200611281227.kASCRhQf077119@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2790
Logged by:          Gurjeet Singh
Email address:      singh(dot)gurjeet(at)gmail(dot)com
PostgreSQL version: 8.2beta3
Operating system:   Windows
Description:        constructor for int2vector seems to be buggy
Details: 

I couldn't find any documentation for the data type 'int2vector', so I
assume it is unsupported. And moreover, probably I am using an unsupported
syntax for populating it, so it may be not that high on priority.

But still filing, in case it uncovers something else.

    In the first INSERT statement, the array elements are separated by a
comma and a space; in the second one, the ones that are separated by just a
comma, do not get inserted!

    I could not reproduce it in standard inetegr arrays.

Session o/p:

postgres=# select version();
                                                version

----------------------------------------------------------------------------
----
------------------------
 PostgreSQL 8.2beta3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3
(mi
ngw special 20030504-1)
(1 row)

postgres=# create table t ( a int2vector );
CREATE TABLE
postgres=# insert into t values ( '1, 2, 3' );
INSERT 0 1
postgres=# insert into t values ( '1,2,3, 4' );
INSERT 0 1
postgres=# select * from t;
   a
-------
 1 2 3
 1 4
(2 rows)

postgres=#

Best regards,

-- 
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | yahoo }.com

Responses

pgsql-bugs by date

Next:From: Thomas H.Date: 2006-11-28 12:34:45
Subject: Re: BUG #2781: database dump/restore problems
Previous:From: Bill MoranDate: 2006-11-28 11:34:39
Subject: Re: BUG #2784: Performance serious degrades over a period

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