egdb3_11_7
.authority
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
simple_heading_search_heading(atag_list integer[], q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text)
Parameters
Name
Type
Mode
atag_list
integer[]
IN
q
text
IN
page
integer
IN
pagesize
integer
IN
thesauruses
text
IN
Definition
SELECT ash.id FROM authority.simple_heading ash, public.naco_normalize($2) t(term), plainto_tsquery('keyword'::regconfig,$2) ptsq(term) WHERE ash.atag = ANY ($1) AND ash.index_vector @@ ptsq.term AND CASE $5 WHEN '' THEN TRUE ELSE ash.thesaurus = ANY(regexp_split_to_array($5, ',')) END ORDER BY ash.sort_value LIMIT $4 OFFSET $4 * $3;