Storing Array values to integer

Question

trying to store array values in integer . this is my code . is it wrong?

db.query('INSERT INTO users(name,student_id) VALUES($1,ARRAY["$2","$3"]::INTEGER[]) RETURNING *', [data.name, data.id])
.then(function(user) { })
.catch(function(err) {
    return callback(null, err);
})

but i am getting this error

{
 "name": "error",
 "length": 102,
 "severity": "ERROR",
 "code": "42703",
 "position": "70",
 "file": "parse_relation.c",
 "line": "3090",
 "routine": "errorMissingColumn"
}

Vao Tsun · Accepted Answer · 2017-05-04 07:18:24Z

1

42703 means undefined_column - this happens, because you use double quotes around "$2","$3" and double quotes are identifying db objects (in this part of the query - columns). Remove them to be:

db.query('INSERT INTO users(name,student_id) VALUES($1,ARRAY[$2,$3]::INTEGER[]) RETURNING *', [data.name, data.id])
.then(function(user) { })
.catch(function(err) {
    return callback(null, err);
})

edited May 4, 2017 at 7:18

answered May 4, 2017 at 7:13

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

katy Over a year ago

yes i removed double quotes and i am getting like this You will need to rewrite or cast the expression

Vao Tsun Over a year ago

it means that ether $1 is of different data type then "name "column, or "student_id" column is not of integer[] data type. but that is totally different question

katy Over a year ago

name column is character , but student_id is integer. i need to store multiple id's to student_id column so do you have any idea on Foreign key constraint for array-field ?

Vao Tsun Over a year ago

you can't put integer[] into integer. It's not about FK

katy Over a year ago

ok actually i would like to store multiple id's to the student_id column of users table. but it has the reference of departments table _id which is declared by int type so if you have any idea please suggest me

|

Collectives™ on Stack Overflow

Storing Array values to integer

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest