While editing/writing a SEDE query I ran into a problem. I used the posts
data table and used an id of 1.
Is that questions or answers? And if not what is the respective id for questions and answers or where can I find that ID information?
Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.
Sign up to join this communityAs you can see by clicking the 'i' by the PostTypes
table (or by running a quick select * from posttypes
), Posts
with a PostTypeID
of 1 are questions; those of 2 are answers.
id
field in thePosts
table is the Question/Answers ID#. The field you're thinking of isPostTypeId
. (Questions=1, Answers=2)