re: auto generated column data: is it possible?

2003-03-21 Thread Victoria Reznichenko
On Thursday 20 March 2003 21:10, Juan Nin wrote: Imagine I have a table with 3 colums (column1, column2, column3), which are of type INT. I want the data in column3 to be generated automatically from the one in column1 and column2 when it is inserted For example a sum, that the data in

Re: Re: auto generated column data: is it possible?

2003-03-21 Thread Juan Nin
From: Victoria Reznichenko [EMAIL PROTECTED] Why do you want to store the sum of columns? You can just sum them when you retrieve data. The database has got about 1 million records, and it gorws day by day The query I need returns lots of records, and calculating it while retrieving data is

auto generated column data: is it possible?

2003-03-20 Thread Juan Nin
Hi, I got the following question: Imagine I have a table with 3 colums (column1, column2, column3), which are of type INT. I want the data in column3 to be generated automatically from the one in column1 and column2 when it is inserted For example a sum, that the data in column3 be the sum of