On Wed, 31 Jul 2002, Zeugswetter Andreas SB SD wrote: > The utility is "Table Partitioning by expression". > > Basically you have a union view like: > create view history as > select * from history2000 where yearcol=2000 > union all > select * from history2001 where yearcol=2001
You want to be careful with this sort of stuff, since the query planner sometimes won't do the view as efficiently as it would do the fully specified equivalant query. I've posted about this here before. cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]