Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> trax=# explain analyze select * from client_search_id_func(62) left join
> tblsearch_selections ON search_id = 62 and user_id = 'RF' and
> ((selected_value = clientno and selection_type = 'client') or (selected_value
> = contactno and selection_ty
"Robert Fitzpatrick" <[EMAIL PROTECTED]> writes:
> Indexes:
> "tblsearch_selections_pkey" PRIMARY KEY, btree (search_selection_id)
> "search_selection_unique_idx" UNIQUE, btree (search_id, user_id,
> selection_value, selection_type)
SELECT *
FROM client_search_id_func(62)
LEFT
I have a function that returns a set of a custom type...
trax=# \d client_search
Composite type "public.client_search"
Column | Type
+
clientno | bigint
client | character varying(100)
contactno | bigint
c
