Yes, postgres has all sorts of features that hadn't been planned on or even conceived of (at least AFAIK) when the project started. It goes far beyond the bog standard SQL queries you'll find in introductory material.