I am querying a single column table, the query output is of text type. I want to check the power of the results. I use the command string_to_array, but I do not know what I need to put for the delimiter. The following two commands do not work:
select rec from papers_stg where cardinality(string_to_array(rec,' ')) <> 11
select rec from papers_stg where cardinality(string_to_array(rec,'\t')) <> 11
Here are the first two lines of table papers_stg:
7B5EDC52 Antibacterial Activity and Post-Antibiotic Effect of Flurithromycin Compared with Other Macrolides and Penicillins Against Periodontal Pathogens antibacterial activity and post antibiotic effect of flurithromycin compared with other macrolides and penicillins against periodontal pathogens 2013 2013/07/18 10.1179/joc.2001.13.3.255 Journal of Chemotherapy journal of chemotherapy 0794F580 19555
7932AE5F In Vitro Activity of Cefdinir against Respiratory Pathogens Isolated in Sicily with Reference to Beta-Lactamase Production in vitro activity of cefdinir against respiratory pathogens isolated in sicily with reference to beta lactamase production 2013 2013/07/18 Journal of Chemotherapy journal of chemotherapy 0794F580 19555
And here is the description of the table:
Table "public.papers_stg"
Column | Type | Modifiers
--------+------+-----------
rec | text |
source
share