BVB Source Codes

parse-server Show json-object-set-keys.sql Source code

Return Download parse-server: download json-object-set-keys.sql Source code - Download parse-server Source code - Type:.sql
  1. -- Function to set a key on a nested JSON document
  2.  
  3. CREATE OR REPLACE FUNCTION json_object_set_key(
  4.   "json"        jsonb,
  5.   key_to_set    TEXT,
  6.   value_to_set  anyelement
  7. )
  8.   RETURNS jsonb
  9.   LANGUAGE SQL
  10.   IMMUTABLE
  11.   STRICT
  12. AS $function$
  13. SELECT concat('{', string_agg(to_json("key") || ':' || "value", ','), '}')::jsonb
  14.   FROM (SELECT *
  15.     FROM jsonb_each("json")
  16.     WHERE KEY <> key_to_set
  17.     UNION ALL
  18.     SELECT key_to_set, to_json("value_to_set")::jsonb) AS FIELDS
  19. $function$;
  20.  
downloadjson-object-set-keys.sql Source code - Download parse-server Source code
Related Source Codes/Software:
react-boilerplate - 2017-06-07
webtorrent - Streaming torrent client for the web ... 2017-06-06
machine-learning-for-software-engineers - A complete daily plan for studying to become a mac... 2017-06-06
upterm - A terminal emulator for the 21st century. 2017-06-06
lottie-android - Render After Effects animations natively on Androi... 2017-06-07
AsyncDisplayKit - Smooth asynchronous user interfaces for iOS apps. ... 2017-06-07
ionicons - The premium icon font for Ionic ... 2017-06-07
storybook - 2017-06-07
prettier - Prettier is an opinionated JavaScript formatter. ... 2017-06-08
CRYENGINE - CRYENGINE is a powerful real-time game development... 2017-06-11
postal - 2017-06-11
reactide - Reactide is the first dedicated IDE for React web ... 2017-06-11
rkt - rkt is a pod-native container engine for Linux. It... 2017-06-11
uWebSockets - Tiny WebSockets https://for... 2017-06-11
realworld - TodoMVC for the RealWorld - Exemplary fullstack Me... 2017-06-11
goreplay - GoReplay is an open-source tool for capturing and ... 2017-06-10
pyenv - Simple Python version management 2017-06-10
redux-saga - An alternative side effect model for Redux apps ... 2017-06-10
angular-starter - 2017-06-10

 Back to top