On 3/7/08, Jamie Tufnell <[EMAIL PROTECTED]> wrote: > On 3/7/08, Bart Degryse <[EMAIL PROTECTED]> wrote: > > I haven't tested these two statements, but I'm using exactly this > > concept on some tables myself. > > My equivalent of your users table contains some 3,000,000 records. > > My equivalent of your sites table contains some 150,000 records. > > And it works fine... > When I try to create the index I get the following error: > > ERROR: functions in index expression must be marked IMMUTABLE > > Out of curiosity, I declared it IMMUTABLE and it worked for the > purposes of my small, isolated test,. > > Am I opening myself up to problems by doing this?
Does anyone have any comment on this? I've done some more testing and have yet to run into a problem. I'd be really interested to hear some opinions on this. Cheers, J. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
