Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

I can't get my head around this, but the votes table in the data dump has no parentPostId column. Only a voteTypeId, a userId, and a postId. Fair enough, but without a parentPostId, how can you validate that a question does not have more than one accepted answer (in other words, a question post does not have more than one vote with a voteTypeId of 1)?

I can't see how you could validate that in the absence of a parentPostId, but I must be missing something!

share|improve this question
2  
Either I'm doing something wrong, or there are such posts: odata.stackexchange.com/stackoverflow/q/14629 – Kobi Nov 22 '10 at 12:45
    
@Kobi: I'm pretty sure that this is just a glitch of the datadump or has a very interesting explanation...but it still is very interesting to see. – Time Traveling Bobby Nov 22 '10 at 14:35
2  
@Bobby No, it's not a glitch in the data dump. Check out this fellow, and more egregiously, this one. You can compare this post to see your standard multi-acceptance behavior. – Grace Note Nov 22 '10 at 14:55
    
@Grace Note: Oh, it's counting the total times of accepting an answer (wait, was that proper English?), I thought something along this lines, but wasn't sure. I'm always amazed on how many data is backing up SE. – Time Traveling Bobby Nov 22 '10 at 14:58
up vote 1 down vote accepted

It goes via the Posts table. Just lookup the ParentId of the post with ID PostId and then check if AcceptedAnswerId is set.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .