On Wed, Oct 21, 2009 at 8:54 PM, semi-ambivalent <thefro...@gmail.com> wrote: > At first blush that looks good but I need an index on that concatted > value and I don't seem to be able to index a field in a view. I'll > check the docs on views to see if I'm missing something.
To create an index on a computed value you use an "index on expression". Here are more details on how to do it: http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
