I saw omnigres mentioned on a shakti mailing list. Many of these concepts have been around with k (kdb) and some other APL-like languages for some time. But Postgres will give these concepts a much broader appeal.
As you rightly point out, the idea behind Omnigres is to make a lot of these concepts available broadly.