"Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> 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