By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
version |
---|
PostgreSQL 9.6.23 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit |
now |
---|
2021-09-06 09:25:59.411269+01 |
1 rows affected
id | prompttype | corpuscode | text | attributes | inputs | comment | created | projectid | promptnum | scriptid | modified |
---|---|---|---|---|---|---|---|---|---|---|---|
209687 | recording | 24-Z-02-669-0001-012 | <html><p>Please read the following prompt: </p><p><span style="color: #ff0000;"><strong><span style="font-size: 14pt;">के म जुलाई पन्ध्रमा बस्ने होटल जाँच गर्नुभएको छ ?</span></strong></span></p></html> | {"prompt": "के म जुलाई पन्ध्रमा बस्ने होटल जाँच गर्नुभएको छ ?", "skippable": false, "sampleRate": 16000, "audioMaxDuration": 60, "audioMinDuration": 4, "locationRequired": true, "maxLeadingSilence": 5, "minLeadingSilence": 0.6, "maxTrailingSilence": 5, "minTrailingSilence": 0.6} | null | 2021-09-01 05:42:15.80726 | 224 | 73 | 10217 | 2021-09-03 16:22:15.80726 |
a |
---|
prompt |
skippable |
sampleRate |
audioMaxDuration |
audioMinDuration |
locationRequired |
maxLeadingSilence |
minLeadingSilence |
maxTrailingSilence |
minTrailingSilence |
ERROR: syntax error at or near "SELECT"
LINE 18: SELECT ARRAY_AGG(f)
^
array_agg |
---|
{prompt,skippable,sampleRate,audioMaxDuration,audioMinDuration,locationRequired,maxLeadingSilence,minLeadingSilence,maxTrailingSilence,minTrailingSilence} |