Insert data in two columns same table

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Insert data in two columns same table
Date: 2016-03-17 01:34:19
Message-ID: CAE_gQfWmkaGpSbKuL_UQAKhQKjDgopdttjqBYS_HJ7dt=Oiwcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to insert data from TABLE A to TABLE B.

1 - Select billable_id from dm.billable
2 - Select mobiuser_id from ja_mobiusers
3 - Insert the billable_id and the mobiuser_id to the dm.billables_links
table.

*FYI -* It has to be in the same transaction because the mobiuser_id must
go to the selected billable_id on the first select.

Well... Would be something like:

> INSERT INTO dm.billables_links (billable_id) VALUES ((SELECT billable_id
> FROM junk.wm_260_billables2 WHERE info ilike '%Alisha%')),
> INSERT INTO dm.billables_links (mobiuser_id) VALUES ((SELECT id FROM
> public.ja_mobiusers WHERE name_first LIKE 'Alisha%' AND name_last LIKE
> 'Dson%'))

The problem is that I need to do that at the same time, because of a
constraint:

ALTER TABLE dm.billables_links
ADD CONSTRAINT cc_one_and_only_one_target CHECK ((("customer_id" IS
NOT NULL)::integer + ("role_id" IS NOT NULL)::integer + ("mobiuser_id"
IS NOT NULL)::integer) = 1);

I'm having trouble by creating that SQL... can anyone help please?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message drum.lucas@gmail.com 2016-03-17 01:41:50 Re: Deleting schema - saving up space - PostgreSQL 9.2
Previous Message drum.lucas@gmail.com 2016-03-17 01:32:07 Re: Unique UUID value - PostgreSQL 9.2