On Fri, Aug 22, 2003 at 10:48:39 +0200,
yruhn <yruhn(at)xdh(dot)nl> wrote:
> Dear anyone,
>
> 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?
Use INSERT and DELETE queries. To get a more specific answer you
need to state what you want to do more precisely.