hey guys i'm using PHP's codeigniter to create my application and postgreSQL as database and i have to update some value in database. So, let's say we have table structure like this:-
CREATE TABLE emailrecord (
id serial NOT NULL,
email json
);
insert first record
INSERT INTO emailrecord (email) VALUES('{"id":"[email protected]"}');
Now, how to update the inserted record at 1 which is to be like this
'{{"id":"[email protected]"},{"id","[email protected]"}}'
AND
is there any way to update it via CODEIGNITER it would be helpful for me
