On 20.03.21 20:16, PG Doc comments form wrote: > So, the last insert command inserted zero rows. What is meant by "there is > no way to insert less than one row"?
I think the point was that you can't insert partial rows.
Sure, if you think its related to the following sentence. If you think its related to the subsequent one it means "cannot insert zero rows". Frankly, both interpretations are wrong, inserting an explicit column list with omitted columns populated using defaults is a "partial row API" for inserting data.
I'm also not fond of the word "conceptually" here - its actually a physical reality that regardless of how one or more rows are supplied they are inserted one-at-a-time so far as constraints, discussed in the previous chapter, are concerned (though some constraints can be deferred).