Re: "there is no way to insert less than one row"
On 25.03.21 00:55, Alvaro Herrera wrote: : When a table is created, it contains no data. The first thing to do : before a database can be of much use is to insert data. Data is : inserted one row at a time. Of course you can also insert : more than one row in a single command, but it is not possible to : insert something that is not a complete row. : Even if you know only some column values, a complete row is created. The next paragraphs explain that omitted columns are defaulted, which IMO flows neatly from here. done that way
Rounding strategy of the 'round' function
Hi, The 'round' mathematical function documentation doesn't specify its rounding strategy. If this would be documented then users can rely on its rounding behavior. For double precision the rounding probably depends on your platform. For numeric the function seems to round to nearest with ties going away from zero (sometimes referred to as "round half up). 6.5 -> 7.0 and -6.5 -> -7.0. https://www.postgresql.org/docs/current/functions-math.html Kind regards, Rudolph
