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.
@rennerocha Opening an issue: create a table with the equivalent functions in each database and blog it. 😀