In pgsql, MySQL converts strings to numbers.

Pgsql

Syntax to_number (text, text)

Example: Select to_number (TRIM (both 'ibs 'from classname), '000000') as CN from BBS order by CN/* trim (both 'ibs' from classname) remove the 'ibs 'character in the classname field */

MySQL

Syntax Str * 1/STR + 1/-str/* STR is the number of varchar, not necessarily 1 here, as long as it is a number */

Hql

Syntax to_number (text, text)

 

Example: Select B from bbs B where B. isdeleted = false order by to_number (TRIM (both 'ibs 'from B. classname), '123 ')

 

 

Pgsql data type Formatting Function