Steff, it all depends whether the pumpkin was a hybrid or heirloom variety. If heirloom, a pure variety, the seed should produce true to type if there was no cross-pollination.
If a hybrid, the result of deliberate cross-breeding between varieties, it should produce pumpkins, but not identical to the parent. Some might well look like the parent, others a bit different. By planting the seed you're on the road to unravelling the gene pool created during the original cross-breeding process. It's always fun to see what you end up with!