"Rajesh Kumar Mallah" <mallah.rajesh@xxxxxxxxx> writes: > I have an index on upper(general.cat_url(category_id)) on a table. > when i add a column *with* default value , a query that previously > used to give result does not give results anymore. REINDEX'ing the > table produces correct result. Can you provide a self-contained example of this? What PG version are you using? What is that nonstandard function you're using in the index? regards, tom lane
