Table "public.dump_dump"
Column | Type | Collation | Nullable | Default
---------------+--------------------------+-----------+----------+-----------------------------------------------------------
code | text | | not null |
code_rendered | text | | not null |
lexer | character varying(30) | | not null |
time_created | timestamp with time zone | | not null | '2011-06-04 07:47:54.579162+00'::timestamp with time zone
comment | character varying(255) | | not null |
user_id | integer | | |
password | character varying(50) | | not null | ''::character varying
updated | timestamp with time zone | | not null |
old_num_id | integer | | |
num_id | bigint | | not null |
Indexes:
"dump_dump_num_id_key" UNIQUE CONSTRAINT, btree (num_id)
"dump_dump_old_num_id_uniq" UNIQUE CONSTRAINT, btree (old_num_id)
"dump_dump_lexer" btree (lexer)
"dump_dump_lexer_like" btree (lexer varchar_pattern_ops)
"dump_dump_time_created" btree (time_created)
"dump_dump_updated" btree (updated)
"dump_dump_user_id" btree (user_id)
Foreign-key constraints:
"user_id_refs_id_48608c9e" FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED
dumpz=# select count(*) from dump_dump order by num_id desc limit 10;
ERROR: column "dump_dump.num_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select count(*) from dump_dump order by num_id desc limit 10...
Что ему надо от меня? 😡
стереть order by ... limit 10?
Обсуждают сегодня