On Wed, Oct 21, 2009 at 8:54 PM, semi-ambivalent <thefronny@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