Re: [GENERAL] when do I analyze after concurrent index creation?

Would a simple multi-column index be considered an 'expression' in this context, meaning that an ANALYZE should be issued after the creation of such an index? --- Pete Yunker Vice President of Data Products Home Junction, Inc. On Oct 18, 2013, at 11:42 AM, Tom Lane wrote: >

Re: [GENERAL] Select duplicated values

COALESCE(x.c,'junk') = COALESCE(y.c,'junk') AND COALESCE(x.d,'junk') = COALESCE(y.d,'junk') AND x.a <> y.a --- Pete Yunker Vice President of Data Products Home Junction, Inc. On Nov 21, 2011, at 5:23 PM, jeffrey wrote: > Lets say that the primar