Great! There are two additional functions that offer quasi-support geography columns:
An example query for creating a buffer of 1 km around Alaska may look like this:
WHERE name = 'Alaska';
What do we mean by quasi-support? Well, these two functions do accept geography parameters, but internally, they still perform calculations using geometry type. PostGIS will look for the best projection available when performing calculations with these functions, but this still means that the results can be inaccurate, even though they will be cast back to geography.