On 06/06/2018 05:07, Jiří Činčura wrote: >> That is still no argument to leave the end of the range out of the >> provided information. Including it will have little to no cost, and >> provides full information in one record, which makes it self-contained >> and easy to understand. > Could it be that the data will be stored without "end" column and for > convenience a view would be provided? I totally get Lester's point. The end > column kind of breaks normalization. > We're talking about a stored procedure, not a table.
There is no problem when a stored procedures returns data to be easily usable. Normalization is not the most important fact in stored procedures result. I understand that is a bit weird to have the end data defined to the .9999 seconds, but it's the max. Firebird precision. If precision increases, it would be increased too, of course. Not returning this output parameter would make user's life only difficult for no good. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
