Hacker News new | ask | show | jobs
by ajcoll5 1687 days ago
Seems to be missing quite a bit.

https://www.babelfishpg.org/docs/usage/limitations-of-babelf...

2 comments

Even cross apply and info schema views, too bad, I used them a lot when I worked with sql server.
Some of these seem to be low-hanging fruit though, like NEWSEQUENTIALID() for example. Would be great to see which are likely to be implemented versus requiring major changes in pgsql to work.
NEWSEQUENTIALID() on SQL server generates a monotonically increasing GUID since last server restart, but monotonicity is not guaranteed between server restarts.

I am not aware of an equivalent function in postgres.