"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
