StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18185198
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-12T10:54:42.417
FavoriteCount
0
LastActivityDate
2013-08-12T11:09:54.433
LastEditDate
2013-08-12T11:09:54.433
LastEditorUserId
6521
OwnerUserId
6521
ParentId
18149039
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
Firstly, consider that there are many numbers which are rational in base 10, but not in a binary floating point representation. For example, the floating point value of 26.82 is actually <code>26.8200000000000002842170943040400743484497</code> Naturally, if you keep adding this to itself some errors creep in, but up to 15 significant digits you should be fine - add this 1000 times and the sum is actually <code>26819.9999999997671693563461303710937500000000</code> The interesting question though is when we multiple 26.82 by 1000.0 we get <code>26820.0000000000000000000000000000000000000000</code> - how does it do that? The answer there is simply that 26820.0 does have an exact binary representation, and the multiplication operation is smart enough to spot that - even multiplying by 1001.0 and subtracting 26.82 would still get you an exact answer. Here's a few interesting links <ul> <li><a href="http://www.h-schmidt.net/FloatConverter/" rel="nofollow">http://www.h-schmidt.net/FloatConverter/</a> - this lets you look at single-precision representation of floating point numbers, and can be useful in really understanding floats</li> <li>This <a href="https://wiki.php.net/rfc/rounding" rel="nofollow">RFC on PHP rounding</a> is tangentially interesting as it covers some of the issues around rounding floats</li> <li>and <a href="http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html" rel="nofollow">What Every Computer Scientist Should Know About Floating-Point Arithmetic</a> </li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhy do I get a different result from two supposedly analogous arithmetic operations?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPaul Dixon
UserOwnerUserId
1. USPaul Dixon
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWhy do I get a different result from two supposedly analogous arithmetic operations?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.