Home > mailing lists

Advice with an insert query - Mailing list pgsql-sql

From	JORGE MALDONADO
Subject	Advice with an insert query
Date	June 7, 2013 13:59:01
Msg-id	CAAY=A7-4fNtC-6akfvfBw2VmqAS0B5+bVxHktWg2qMztV21KEA@mail.gmail.com Whole thread
Responses	Re: Advice with an insert query Re: Advice with an insert query Re: Advice with an insert query
List	pgsql-sql

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

From: Jayadevan
Date: 05 June 2013, 04:24:11
Subject: Re: crosstab help

From: Andreas Gaab
Date: 07 June 2013, 14:01:27
Subject: Re: Advice with an insert query