ifnull in postgresql code example

Example 1: ifnull postgres

SELECT coalesce(column, 1)

Example 2: st_buffer mysql

ST_Buffer(g, d[, strategy1[, strategy2[, strategy3]]])

Example 3: postgresql gset

=> SELECT 'hello' AS var1, 10 AS var2
-> \gset
=> \echo :var1 :var2
hello 10