James Harper <james@ejbdigital.com.au> writes:
Postgres is highly extensible. I wrote compatible types for my mssql emulator to avoid exactly that problem (being Microsoft, they have their own ideas of how types should behave, and also I could make the underlying data format compatible with the wire format).
I'd be doing a complete parse and rewrite of the language though, so any of the language and type differences would be easily solvable. Some of the other differences your links highlight around foreign key and atomicity behaviour would be harder.
On the plus side, a lot of apps don't care that much if at all :) OTOH, it may not be worth the effort if it's just one simple app... but that doesn't mean it wouldn't be a *lot* of fun and a good challenge to try and do it :) -- Stewart Smith