SQLize Online / PHPize Online  /  SQLtest Online

Create table shelf( id SERIAL PRIMARY KEY, word VARCHAR(40) NOT NULL ); CREATE TABLE deck( id SERIAL PRIMARY KEY, word VARCHAR(40) NOT NULL ); INSERT INTO shelf (word) VALUES('Слово'); CREATE OR REPLACE FUNCTION get_line() RETURNS VOID AS $$ DECLARE rec RECORD; CURSOR cursorchik FOR SELECT * FROM shelf; BEGIN OPEN cursorchik; FETCH FIRST FROM cursorchik INTO rec; INSERT INTO deck (word) VALUES rec.word; CLOSE cursorchik; END; $$ LANGUAGE plpgsql; ALTER TABLE shelf ADD COLUMN number INTEGER NOT NULL DEFAULT 1, ADD COLUMN sec INTEGER NOT NULL DEFAULT 2; INSERT INTO shelf (word, number, sec)VALUES('тест', 4, 5), ('проверка', 3, 4); SELECT * FROM shelf; INSERT INTO deck (word) VALUES('Не слово'); INSERT INTO deck (word) VALUES('не тест'); SELECT shelf.word, deck.id, deck.word FROM shelf INNER JOIN deck ON shelf.id = deck.id; UPDATE shelf SET number = 6 WHERE word = 'тест'; SELECT * FROM shelf; UPDATE shelf SET sec = (SELECT MIN(sec) from shelf) WHERE sec = (SELECT MAX(sec) from shelf); SELECT * FROM shelf; SELECT word FROM shelf; SELECT word, number FROM shelf WHERE word = 'Слово'; ALTER TABLE shelf DROP COLUMN sec; SELECT * FROM shelf; SELECT * FROM shelf ORDER BY number DESC; SELECT * FROM shelf;