Many of the functions/operators Postgres provides are standard compliant (with some extensions to the standard, e.g. writing INTERVAL constants)
If the "other" RDBMS is Oracle, then they will be very similar.
If the "other" are SQL Server or MySQL, then it will indeed be very different.