Below is my table structure
CREATE TABLE configurations
(
id serial NOT NULL,
key text,
description text,
value text,
CONSTRAINT configurations_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
I am inserting data with below query
insert into configurations
(id, key, description, value)
select 1,'key1','D1',25
UNION
select 2,'key2','D2',365
UNION
select 3,'key3','D3','2017-01-01'
But i am getting below error
ERROR: invalid input syntax for integer: "2017-01-01"
LINE 7: select 3,'key3','D3','2017-01-01'
I don't know why i am getting this error. value "2017-01-01" is a text value and column data type is also text then why i am getting integer specific error.