2016-09-28 10:25 GMT+13:00 Patrick B <patrickbakerbr@gmail.com>:Actually I can't use name_last or name_first because some of the rows have name_last/name_first = nullI'm inserting more columns that I shown:CREATE TABLE public.not_monthly ( id BIGINT DEFAULT "nextval"('"not_monthly_id_seq"'::"regclass") NOT NULL, clientid BIGINT, name_first CHARACTER VARYING(80) DEFAULT ''::CHARACTER VARYING, name_last CHARACTER VARYING(80) DEFAULT ''::CHARACTER VARYINGcompany_name CHARACTER VARYING(80)); but the only value that is commun between table_1 and table_2 is the clientid and c_id.Clientid is the same for all the rowsc_Id is the column I need to update from the inserted on table_1So.. not many options here
CREATE TABLE public.not_monthly ( id BIGINT DEFAULT "nextval"('"not_monthly_id_seq"'::"regclass") NOT NULL, clientid BIGINT, name_first CHARACTER VARYING(80) DEFAULT ''::CHARACTER VARYING, name_last CHARACTER VARYING(80) DEFAULT ''::CHARACTER VARYINGcompany_name CHARACTER VARYING(80));
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных