Example to convert a field from real type to integer type:
update bracketevents set json = jsonb_set(json, '{sq_id}', ((round(cast(json->>'sq_id' as real))::text)::jsonb)); All that just remove the $*(@ decimals… how particular…
-
-
-
Categories
- Projects
(197)
- A better Trader (16)
- Gaming (5)
- HangTheDJ (27)
- iPhone (9)
- Linux Projects (50)
- MythTV (18)
- ShareTheDJ (10)
- MythTV
- Open Source (65)
- quick-http (7)
- rad-scripts (7)
- Websites (64)
- Firefox (11)
- Mediawiki (5)
- Phabricator (4)
- Wordpress (11)
- Firefox
- Windows (36)
- A better Trader
- Tricks Tips Tools (276)
- C (2)
- C++ (34)
- d3 (3)
- Gentoo Server (30)
- git (7)
- i3 (1)
- node-js (13)
- PHP (10)
- Ubuntu Desktop (1)
- C
- Projects
-
Recent Posts
- systemd-resolved hates your LAN’s single-label hosts
- “Free” domain email (just costs your soul)
- Wayback SO
- C++11 thread_local set us up the bomb
- Postgres JSONB field type conversion
- Print long C++ strings with gdb in Visual Studio Code
- Getting pretty Google fonts into WordPress
- Today’s broswer rank: Ecosia, Chrome, Firefox
- Shiny shiny updates
- Visual Studio Code save+compile+debug
- ClassNames functionNames and member_variable_names_
- The ultimate DRY: Always generate your code from JSON schema
- How to fix your node apps after an NPM bump
- Ubuntu and i3 and power management
- Whiteboarding success
- gcc achieving consciousness?
- Constant Improvement
- bump day: Gentoo profile v17, apache, python, PHP, a year of Simple-Web-Server updates…
- Node dependency headaches
- C++11 interactive thread
- Strive to reduce your NPM dependencies
- Diamond Dependecy pattern
- ssh ProxyJump has liftoff
- Compulsory IDE
- Gentoo rock steady
- Another day, another mesmerizing visualization
- JWT in C++
- Datetime crushed with C++ boost::gregorian::date and ptime and Javascript moment and bootstrap-datepicker
- d3 teaches
- haproxy p0wn3s all your ssl bases
-
Archive
%d bloggers like this: