libz509pq--1.0.sql

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION libz509pq" to load this file. \quit

CREATE OR REPLACE FUNCTION z509_issuerName(bytea,integer DEFAULT NULL) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_keyAlgorithm(bytea) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_keySize(bytea) RETURNS integer
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_notAfter(bytea) RETURNS timestamp
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_notBefore(bytea) RETURNS timestamp
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_publicKeyMD5(bytea) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_publicKey(bytea) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_rsaModulus(bytea) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_serialNumber(bytea) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_signatureHashAlgorithm(bytea) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_signatureKeyAlgorithm(bytea) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_subjectName(bytea,integer DEFAULT NULL) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_name(bytea,boolean DEFAULT TRUE) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_name_print(bytea,integer DEFAULT NULL) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_commonName(bytea) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_subjectKeyIdentifier(bytea) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_authorityKeyId(bytea) RETURNS bytea
	AS '$libdir/libz509pq.so' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_extKeyUsages(bytea,boolean DEFAULT TRUE) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_isEKUPermitted(bytea,text) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_certPolicies(bytea) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_isPolicyPermitted(bytea,text) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_canIssueCerts(bytea) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_getPathLenConstraint(bytea) RETURNS integer
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_nameAttributes(bytea,text,boolean,boolean DEFAULT TRUE) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE TYPE zname_raw_type AS (
	ATTRIBUTE_OID		text,
	RAW_VALUE		bytea
);

CREATE OR REPLACE FUNCTION z509_nameAttributes_raw(bytea,boolean DEFAULT TRUE) RETURNS SETOF zname_raw_type
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_altNames(bytea,integer DEFAULT NULL,boolean DEFAULT TRUE,boolean DEFAULT TRUE) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE TYPE zaltname_raw_type AS (
	TYPE_NUM		integer,
	RAW_VALUE		bytea,
	OTHER_NAME_OID	text
);

CREATE OR REPLACE FUNCTION z509_altNames_raw(bytea,boolean DEFAULT TRUE) RETURNS SETOF zaltname_raw_type
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_cRLDistributionPoints(bytea) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_authorityInfoAccess(bytea,integer DEFAULT NULL) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_print(bytea,integer DEFAULT NULL,integer DEFAULT NULL) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_verify(bytea,bytea) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_anyNamesWithNULs(bytea) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_extensions(bytea,boolean DEFAULT TRUE) RETURNS SETOF text
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_hasExtension(bytea,text,boolean DEFAULT NULL) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_tbscert_strip_ct_ext(bytea) RETURNS bytea
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_hasROCAFingerprint(bytea) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION z509_hasClosePrimes(bytea,smallint DEFAULT 100) RETURNS boolean
	AS 'MODULE_PATHNAME' LANGUAGE c IMMUTABLE;

CREATE OR REPLACE FUNCTION zurlEncode(text) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION zurlDecode(text) RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION z509pq_opensslVersion() RETURNS text
	AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION cert_compress(bytea, bytea DEFAULT NULL, integer DEFAULT NULL) RETURNS bytea
    AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION cert_decompress(bytea, bytea DEFAULT NULL) RETURNS bytea
    AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE;