Postgres Pro
Downloads
Home   >   mailing lists

Re: Advice with an insert query - Mailing list pgsql-sql

From Oliver d'Azevedo Cristina
Subject Re: Advice with an insert query
Date
Msg-id 6B78B72D-0B1E-4CBC-A9D5-9029A5C4CED5@gmail.com
Whole thread Raw
In response to Advice with an insert query  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-sql
Tree view
Just pass the fixed value for inside the select subquery. 
Do this

INSERT INTO table1 fld1, fld2, fl3
VALUES  (SELECT value1, fldx, fldy FROM table2)

HTH

Best,
Oliver 



Enviado via iPhone

Em 07/06/2013, às 02:58 PM, JORGE MALDONADO <jorgemal1960@gmail.com> escreveu:

I need to insert records into a table where one value is fixed and 2 values come from a SELECT query, something like the following example:

INSERT INTO table1 fld1, fld2, fl3
VALUES value1, (SELECT fldx, fldy FROM table2)

Is this valid?

Respectfully,
Jorge Maldonado

pgsql-sql by date:

Previous
From: Andreas Gaab
Date:
Subject: Re: Advice with an insert query
Next
From: Thomas Kellerer
Date:
Subject: Re: Advice with an insert query