Pinned Loading

1. aresty aresty Public

   Rust

2. Multiple functions to modify json ob... Multiple functions to modify json objects in PostgreSQL

   1

   -- Aggregate function to aggregate key-value pairs to json object (opposite of json_each())

   2

   -- requires PostgreSQL 9.3+ (but < 9.4!)

   3

   -- requires function "json_object_set_key"

   4

   5

   DROP AGGREGATE IF EXISTS "json_object_agg" (TEXT, anyelement);

3. PostgreSQL function to test if two j... PostgreSQL function to test if two json values are equal

   1

   -- SQL function to test if two json values are equal

   2

   -- requires PostgreSQL 9.3+

   3

   4

   CREATE OR REPLACE FUNCTION json_equals(json, json)

   5

     RETURNS BOOLEAN

4. Base convert functions for PostgreSQL Base convert functions for PostgreSQL

   1

   -- SQL function to convert numbers from custom bases to numeric

   2

   -- requires PostgreSQL 9.3+

   3

   4

   CREATE OR REPLACE FUNCTION number_from_base(num TEXT, base INTEGER)

   5

     RETURNS NUMERIC