Advice with an insert query
| От | JORGE MALDONADO |
|---|---|
| Тема | Advice with an insert query |
| Дата | |
| Msg-id | CAAY=A7-4fNtC-6akfvfBw2VmqAS0B5+bVxHktWg2qMztV21KEA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Advice with an insert query
Re: Advice with an insert query Re: Advice with an insert query |
| Список | pgsql-sql |
<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">I need to insert records into a table where onevalue is fixed and 2 values come from a SELECT query, something like the following example:</span><div style="font-family:arial,sans-serif;font-size:13px"><br/></div><div style="font-family:arial,sans-serif;font-size:13px">INSERTINTO table1 fld1, fld2, fl3</div><div style="font-family:arial,sans-serif;font-size:13px">VALUESvalue1, (SELECT fldx, fldy FROM table2)</div><div style="font-family:arial,sans-serif;font-size:13px"><br/></div><div style="font-family:arial,sans-serif;font-size:13px">Isthis valid?</div><div style="font-family:arial,sans-serif;font-size:13px"><br/></div><div style="font-family:arial,sans-serif;font-size:13px">Respectfully,</div><div style="font-family:arial,sans-serif;font-size:13px">JorgeMaldonado</div></div>
В списке pgsql-sql по дате отправления: