Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

rootpgsqlshareextensionhstore--1.2--1.3.sql

hstore--1.2--1.3.sql18 linesDownload Raw Back to extension

1/* contrib/hstore/hstore--1.2--1.3.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION hstore UPDATE TO '1.3'" to load this file. \quit5 6CREATE FUNCTION hstore_to_jsonb(hstore)7RETURNS jsonb8AS 'MODULE_PATHNAME', 'hstore_to_jsonb'9LANGUAGE C IMMUTABLE STRICT;10 11CREATE CAST (hstore AS jsonb)12  WITH FUNCTION hstore_to_jsonb(hstore);13 14CREATE FUNCTION hstore_to_jsonb_loose(hstore)15RETURNS jsonb16AS 'MODULE_PATHNAME', 'hstore_to_jsonb_loose'17LANGUAGE C IMMUTABLE STRICT;18