Андрей Буров

SELECT * FROM comment ORDER BY array_length(path, 1) ASC, rating DESC

# Query the database and obtain data as Python objects
>>> cur.execute("SELECT * FROM test;")
>>> cur.fetchone()
(1, 100, "abc'def")

# Make the changes to the database persistent
>>> conn.commit()

DELETE FROM table WHERE (page_id, template_id) IN (SELECT page_id, template_id FROM table WHERE ....)

delete from Чат where id IN (select id from Чат where Тема='427c6f3e-9876-48c5-b44d-776771f7c2c9' LIMIT 1000)

burik=# create table test (id serial not null primary key, value integer);
CREATE TABLE
burik=# alter sequence test_id_seq maxvalue 2;
ALTER SEQUENCE
burik=# insert into test (value) VALUES(1);
INSERT 0 1
burik=# insert into test (value) VALUES(2);
INSERT 0 1
burik=# insert into test (value) VALUES(3);
ERROR:  nextval: reached maximum value of sequence "test_id_seq" (2)

(params->'sex')::text::integer = ANY (ARRAY[1,2,3]);