AttentionThis page documents an earlier version. Go to the latest (v2.3) version.
Save this script as
-- Suppress the spurious warning that is raised -- when the to-be-deleted view doesn't yet exist. set client_min_messages = warning; drop view if exists t4_view; create view t4_view as select k, int_score as score from t4; -- This very simple view allows updates. drop view if exists results; create view results as select method, bucket, n, min_s, max_s from int_results;