Comparison with previous snippet
- --- Previous Snippet
-
- +++ Current Snippet
-
- @@ -10 +10,11 @@
-
- GROUP BY charac;
- +
- +
- +#### EDIT
- +
- +SELECT char, count(*) as frequency
- +FROM "core_linetranscription", regexp_split_to_table(content, '') t(char), core_line, core_documentpart
- +WHERE "core_linetranscription"."line_id" = "core_line"."id"
- +AND "core_line"."document_part_id" = "core_documentpart"."id"
- +AND ("core_documentpart"."document_id" = 296 AND "core_linetranscription"."transcription_id" = 391)
- +GROUP BY char;
- SELECT charac, count(*) as frequency
- FROM (
- SELECT regexp_split_to_table(content, '')
- FROM (
- SELECT STRING_AGG(content, '') as content
- FROM "some_table"
- WHERE "some_condition" = 'is_met'
- ) charac(l)
- )
- GROUP BY charac;
-
-
- #### EDIT
-
- SELECT char, count(*) as frequency
- FROM "core_linetranscription", regexp_split_to_table(content, '') t(char), core_line, core_documentpart
- WHERE "core_linetranscription"."line_id" = "core_line"."id"
- AND "core_line"."document_part_id" = "core_documentpart"."id"
- AND ("core_documentpart"."document_id" = 296 AND "core_linetranscription"."transcription_id" = 391)
- GROUP BY char;