Re: INSERTing datastructure into table with GENERATED ALWAYS column.

Charles,

This is the first time I have used all columns in my sql. As you suggested, I normally explicitly define the columns.

But the program I am working on is an interface program which populates a third part interface file(s). Currently there are fields in the interface file that we don't know the value of. Those values will be added later.

How I meant that it would save me time was that outputting a data structure and not a list of columns was that in the near future when the values are known I only have to assign a value to the output data structure. I don't have to change the list of columns in the output sql statement.

Rob


On 1/23/2017 3:45 PM, Charles Wilt wrote:

On Mon, Jan 23, 2017 at 1:40 PM, Robert Rogerson <rrogerson@xxxxxxxxxxx>
wrote:

Being able to insert from a data structure without hard coding a list of
columns will save a lot of time.

​Only today...

It will take more time in the future.

Add a column to your table...now try to run your program.

SELECT * and it's equivalent of INSERT without columns named should not be
in production code when the FROM clause contains a physical table.

Charles​