Coalesce

https://qastack.kr/programming/2214525/what-is-the-postgresql-equivalent-for-isnull

t-sql vs ansi sql
https://excelsior-cjh.tistory.com/181

postgresql

stuff

select stuff('abcde', 2, 3, 'kk'); --akke

convert & CAST

CONVERT(VARCHAR(19), MIN(ACT_DATETIME) , 120)
https://infodbbase.tistory.com/7
CAST('80' AS INT)

row_number()

SELECT ROW_NUMBER() OVER (
PARTITION BY GROUP_ID
ORDER BY CREATED_AT DESC) AS rn,
*
FROM TABLE_A

with

https://heodolf.tistory.com/71

geometry

STAsText
ST???
STIntersection
STGeomFromText
GEOMETRYCOLLECTION