 ) WITHOUT OIDS;
 
 grant select on psprotcomp_location to PUBLIC;
-
-create function protcomp_psloc_id(text) returns integer
-strict immutable language sql as '
-select psloc_id from psprotcomp_location where location=$1;
-';
+comment on table psprotcomp_location is 'Softberry protcomp location lookup table';
 
 insert into psprotcomp_location(psloc_id,location) values (0,'no prediction');
 insert into psprotcomp_location(location) values ('Cytoplasmic');

CREATE UNIQUE INDEX psprotcomp_search3 ON psprotcomp (params_id,int_psloc_id,int_score,pseq_id);
grant select on psprotcomp to PUBLIC;
grant insert on psprotcomp to loader;



-- pfprotcomp
-- ----------
-- tm,sig,gpi
-- COULD BE EXTRACTED FROM result_block

insert into psprotcomp_location(location) values ('Nuclear');
insert into psprotcomp_location(location) values ('Peroxisomal');
insert into psprotcomp_location(location) values ('Plasma membrane');



