Re: [SQL] Inserting data in a table using sub-selects]

INSERT INTO table2 (id, content) ( SELECT id, coalesce(title, '') || ' ' || coalesce(description, '') FROM table1 t1); If you want to keep them syncrhonized, in other words, rerun the query over and over again without having to truncate table2 first or deleting all of the rows, you can: INSER

[SQL] correlated multi-set update?

Hello, My company recently deployed Pg 7.4.1. on Solaris for an experimental project and is using the experience to evaluate its viability for migration from Oracle 7.0. While I like a lot of the features of Pg, one thing I noticed that "seems" to be missing is the ability to set multiple fiel