如题所述
å¹é
è§åå¦ä¸ï¼
"^\d+$"ãã //éè´æ´æ°ï¼æ£æ´æ° + 0ï¼
"^[0-9]*[1-9][0-9]*$"ãã //æ£æ´æ°
"^((-\d+)|(0+))$"ãã //éæ£æ´æ°ï¼è´æ´æ° + 0ï¼
"^-[0-9]*[1-9][0-9]*$"ãã //è´æ´æ°
"^-?\d+$"ãããã //æ´æ°
"^\d+(\.\d+)?$"ãã //éè´æµ®ç¹æ°ï¼æ£æµ®ç¹æ° + 0ï¼
"^(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*))$"ãã //æ£æµ®ç¹æ°
"^((-\d+(\.\d+)?)|(0+(\.0+)?))$"ãã //éæ£æµ®ç¹æ°ï¼è´æµ®ç¹æ° + 0ï¼
"^(-(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*)))$"ãã//è´æµ®ç¹æ°
"^(-?\d+)(\.\d+)?$"ãã //æµ®ç¹æ°
PostgreSQLæ¯ææ£å表达ï¼UDFå½æ°ï¼å¯ä»¥å®æè¿é¡¹å·¥ä½ã
"^\d+$"ãã //éè´æ´æ°ï¼æ£æ´æ° + 0ï¼
"^[0-9]*[1-9][0-9]*$"ãã //æ£æ´æ°
"^((-\d+)|(0+))$"ãã //éæ£æ´æ°ï¼è´æ´æ° + 0ï¼
"^-[0-9]*[1-9][0-9]*$"ãã //è´æ´æ°
"^-?\d+$"ãããã //æ´æ°
"^\d+(\.\d+)?$"ãã //éè´æµ®ç¹æ°ï¼æ£æµ®ç¹æ° + 0ï¼
"^(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*))$"ãã //æ£æµ®ç¹æ°
"^((-\d+(\.\d+)?)|(0+(\.0+)?))$"ãã //éæ£æµ®ç¹æ°ï¼è´æµ®ç¹æ° + 0ï¼
"^(-(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*)))$"ãã//è´æµ®ç¹æ°
"^(-?\d+)(\.\d+)?$"ãã //æµ®ç¹æ°
PostgreSQLæ¯ææ£å表达ï¼UDFå½æ°ï¼å¯ä»¥å®æè¿é¡¹å·¥ä½ã
温馨提示:答案为网友推荐,仅供参考