Re: [GENERAL] SELECT...VIEW...UNION...LIMIT

2004-11-24 Thread Greg Stark
"Ed L." <[EMAIL PROTECTED]> writes: > create view big_view as > select *, 'big_table'::varchar as source from big_table > union > select *, 'small_table'::varchar as source from small_table; Try "UNION ALL" instead of just "union" The difference i

[GENERAL] SELECT...VIEW...UNION...LIMIT

2004-11-24 Thread Ed L.
I have "big_table" (1M rows) and "small_table" (1K rows) with identical schemas and together in a view as follows: create view big_view as select *, 'big_table'::varchar as source from big_table union select *, 'small_table'::varchar as sou