add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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}