3

I found that FavoriteCount column in Posts table in SEDE contains both NULL and 0 values for "questions" (PostType = 1). Why some questions have Null instead of zero?

Improve this question

1 Answer 1

Reset to default
7

If it has never been set to anything it would usually be null.

However, if it was made favourite and then the favourite vote removed, it would end up with a 0 score.

Improve this answer
3
  • 1
    So I guess that means we can use SEDE to find out if a question has ever been favorited by anyone in the past. I'm not quite sure what to do with that information, but I'm sure somebody's curious about it.
    – Ilmari Karonen
    Oct 13, 2017 at 19:52
  • Thanks much! I guess same thing goes for Posts.Score cause it also contains both 0 & NULL values.
    – Layray
    Oct 16, 2017 at 19:35
  • 1
    @Layray - basically. The SQL columns default to null (for a good few columns). If there were writes to it, it would change to a value.
    – Oded
    Oct 16, 2017 at 20:01

You must log in to answer this question.

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