I have a vector layer (call it master) that is stored in postgis and consists of a number of line segments.
I also have a collection of sub layers that consist of subsets of the master layer. I can set up a 'link' table master_id, layer_name the says which segments belong to which sub layer -- some on the edges will be common.
Can I specify a layer using an join on the master and link tables?
Alternatively can I use a view at the postgres level to do this. I have never used views or stored procedures although I know the general principles.