你即將離開本站

並前往https://intellipaat.com/community/14851/how-do-i-cast-a-string-to-integer-and-have-0-in-case-of-error-in-the-cast-with-postgresql

How do I cast a string to integer and have 0 in case of error in

Use the query as follows: SELECT myfield::integer FROM mytable WHERE myfield ~ E'^\\d+$';. In Postgres, you can't get any non-integers ...

確定！ 回上一頁

查詢 「PostgreSQL CAST」的人也找了：

  1. PostgreSQL CAST
    2.
  2. PostgreSQL substring
    3.
  3. PostgreSQL EXTRACT
    4.
  4. PostgreSQL cast to string
    5.
  5. PostgreSQL to_char
    6.
  6. postgres try cast
    7.
  7. PostgreSQL round
    8.
  8. PostgreSQL to_number
    9.