I propose inversion function to pg_size_pretty function - like pg_human_size.
Usage:
SELECT * FROM pg_class WHERE pg_table_size(oid) > pg_human_size('2GB');
I'm not a big fan of the name, but +1 on the general idea.
I am for any other good name
Maybe pg_size_pretty(text)?
I understand to your idea, but it can be too strange - function and inversion function share same name.
What about pg_size(text), pg_size(value bigint, unit text) ?
Regards
Pavel
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com