Hi all,
I have an existing table containing a column in it containing a money value. I would like to normalise this column into a separate table, as the money value is to be expanded to contain a tax value, etc.
I have been trying to find a SQL query that will do the following:
- Select the money column from the table
- Populate the new normalised table with each row containing the value from the original money column
- Write the primary keys of the new rows in the normalised table, back to a new column in the original table added for this purpose.
This third step I am struggling with - can anyone suggest a query that might achieve the writing back of the primary key to the original table?
Regards, Graham --
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
