Dear anyone,
I wish to update an entire table with just using (PostGre)SQL (=preferably without
resorting to C, Python or so). Can I? If so how?
For example, I want to update/replace table:
a | b | c
---+---+---
1 | 2 | 3
4 | 5 | 6
7 | 8 | 9
with table:
a | b | c
---+---+---
1 | 2 | 2
4 | 5 | 6
9 | 0 | 0
So, I wish to:
1- update every data point in the table (based on the UNIQUE column 'a' (=PRIMARY
KEY)), and if this value of a is not present (such as for instance value 9: 9,0,0),I
wish to;
2- insert a new row with data points
3- and I want to delete old rows that are not used present in the new table (such as
row 7 : 7,8,9)
How can I update an entire table with just using (PestGre)SQL?
Lots of thanks for any help anyone can give me,
Wiliam Knobbel, PhD-Student
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
