is it possible to created materialized view in postgresql 8.3 if yes please provide some sample.
in older versions, the best you could do was to create a table and populate it with your 'view', then drop it when you're done (or truncate and repopulate it to update the 'view').
--
john r pierce 37N 122W
somewhere on the middle of the left coast
