oai Functions
This page documents all 4 function(s) in the oai schema.
Function Index
| Function | Return Type | Language | Volatility | Security |
|---|---|---|---|---|
|
sql |
STABLE |
||
|
sql |
STABLE |
||
|
sql |
STABLE |
||
|
sql |
STABLE |
auth_is_visible_by_axis
Signature: oai.auth_is_visible_by_axis(auth bigint, ax text)
Returns: boolean
Language |
sql |
Volatility |
STABLE |
Strict |
No |
Security Definer |
No |
SELECT EXISTS (SELECT 1 FROM authority.browse_axis_authority_field_map m JOIN authority.simple_heading r on (r.atag = m.field AND r.record = auth AND m.axis = ax))bib_is_visible_at_org_by_copy
Signature: oai.bib_is_visible_at_org_by_copy(bib bigint, org integer)
Returns: boolean
Language |
sql |
Volatility |
STABLE |
Strict |
No |
Security Definer |
No |
WITH corgs AS (SELECT array_agg(id) AS list FROM actor.org_unit_descendants(org))
SELECT EXISTS (SELECT 1 FROM asset.copy_vis_attr_cache, corgs WHERE vis_attr_vector @@ search.calculate_visibility_attribute_test('circ_lib', corgs.list)::query_int AND bib=record)bib_is_visible_at_org_by_luri
Signature: oai.bib_is_visible_at_org_by_luri(bib bigint, org integer)
Returns: boolean
Language |
sql |
Volatility |
STABLE |
Strict |
No |
Security Definer |
No |
WITH lorgs AS(SELECT array_agg(id) AS list FROM actor.org_unit_ancestors(org))
SELECT EXISTS (SELECT 1 FROM biblio.record_entry, lorgs WHERE vis_attr_vector @@ search.calculate_visibility_attribute_test('luri_org', lorgs.list)::query_int AND bib=id)bib_is_visible_by_source
Signature: oai.bib_is_visible_by_source(bib bigint, src text)
Returns: boolean
Language |
sql |
Volatility |
STABLE |
Strict |
No |
Security Definer |
No |
SELECT EXISTS (SELECT 1 FROM biblio.record_entry b JOIN config.bib_source s ON (b.source = s.id) WHERE transcendant AND s.source = src AND bib=b.id)