What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

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

1 Answer 1

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 .