· 9 years ago · Oct 12, 2016, 05:26 PM
1CREATE OR REPLACE FUNCTION reset_data()
2RETURNS void AS $$
3BEGIN
4DROP TABLE IF EXISTS experiment;
5SELECT * INTO experiment FROM original;
6END;
7$$ LANGUAGE plpgsql;
8
9ERROR: "experiment" is not a known variable
10LINE 5: SELECT * INTO experiment FROM original;
11 ^
12
13********** Error **********
14
15ERROR: "experiment" is not a known variable
16SQL state: 42601
17Character: 113