StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7408236
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-09-13T20:45:16.220
FavoriteCount
0
LastActivityDate
2011-09-13T20:45:16.220
LastEditDate
LastEditorUserId
0
OwnerUserId
53013
ParentId
7407441
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
There's lots of way of doing this without using the <code>if</code> statement, but still resorting to comparing the numbers. That would be simply hiding an implicit <code>if</code> statement behind something else. One alternative to <code>if</code> statements in object-oriented languages is polymorphism. Consider this: <pre><code>sealed trait Bool object Bool { def apply(b: Boolean): Bool = b match { case true /* Implicit if! */ => True case false => False object True extends Bool object False extends Bool </code></pre> From a <code>Boolean</code> you can construct a <code>Bool</code> (using an implicit <code>if</code>, granted). You can then add a method to <code>Bool</code>, implementing it differently for each <code>object</code>. This is how <code>Option</code> works, by the way. <code>None</code> has one implementation, and <code>Some</code> has another. There's one way to avoid comparing the numbers, however. If you don't compare, you don't use <code>if</code> either -- not even implicitly. Fun fact: a computer magazine back in the 80s had a contest for sorting algorithms, the winner of which would be the one comparing the fewest time. The winning algorithm sorted entirely without comparing, and then did a dummy compare just to stay within the rules of the contest. The tip here is that you have to know what the range of the numbers is, and that range cannot be too big, or, otherwise, you'll have to do multiple passes to finish the ordering. Also, lists are inefficient to perform the operations. I hope this helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCompare Integers without if statement?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDaniel C. Sobral
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
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
CommentsPostId
1. COThe technique Daniel hints at at the end is the one that would get my vote as genuinely avoiding conditionals as opposed to encoding them out of sight somehow.
 singulars
 PostPostId
 PO
 UserUserId
 USMiles Sabin

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.