[SQL] Advice with an insert query

2013-06-07 Thread JORGE MALDONADO 
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

Re: [SQL] Advice with an insert query

2013-06-07 Thread Andreas Gaab 
INSERT INTO table1 (fld1, fld2, fl3)
VALUES (SELECT value1, fldx, fldy FROM table2);

should work,

Andreas


Von: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] Im 
Auftrag von JORGE MALDONADO
Gesendet: Freitag, 7. Juni 2013 15:59
An: pgsql-sql@postgresql.org
Betreff: [SQL] Advice with an insert query

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

Re: [SQL] Advice with an insert query

2013-06-07 Thread Oliver d'Azevedo Cristina 
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  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

Re: [SQL] Advice with an insert query

2013-06-07 Thread Thomas Kellerer 
JORGE MALDONADO, 07.06.2013 15:58:
> 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


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





-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql