Distance Constraints with PostgreSQL and PostGIS

Note: there's an error that I'll correct once I'm back at my computer... All my latitude longitude pairs are flipped :(