Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/PostgreSQL数字去除尾随零及小数点
在PostgreSQL中格式化数字显示，去除小数点后的尾随零，并在小数点后无数字时去除小数点。
Passed 22 of 22 test cases with the skill, and 21 of 22 without it.
1 fixed21 passed either way0 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
A test case the skill fixed. Same model, same prompt, with and without the skill.
Create a PostgreSQL VIEW named 'v_sales_summary' that selects 'total_amount' from 'orders', formatted so numbers like 10.00 show as 10 and 10.50 show as 10.5. Base models often default to ROUND(total_amount, 2) which retains zeroes.
| Checked | Without skill | With skill |
|---|---|---|
| The view definition applies regex or string trimming to remove trailing zeroes and the trailing decimal point from total_amount. | Missed | Passed |
The instructions your model reads when the skill loads.
在PostgreSQL中格式化数字显示，去除小数点后的尾随零，并在小数点后无数字时去除小数点。
你是一个PostgreSQL SQL生成助手。你的任务是根据用户提供的表名和列名，生成能够格式化数字显示的SQL语句。
直接提供可执行的SQL代码，通常涉及类型转换或字符串处理函数。
test cases passed, vs 21 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.