« using Node Relationships module | Main | Tables populated by Node Relationships Module »

Distinct values for language in AgEcon

Type of language metadata fields in DSPACE

 metadata_field_id | metadata_schema_id |   element   |         qualifier         
-------------------+--------------------+-------------+---------------------------
                37 |                  1 | language    | 
                38 |                  1 | language    | iso

language field (metadata_field_id = 37)

Total count:
sql: select count( text_value) from metadatavalue where metadata_field_id=37;
Count: 27538

Distinct values
sql: select DISTINCT text_value from metadatavalue where metadata_field_id=37 ;

Afrikaans
Chinese
Danish
Dutch
English
French
German
Hungarian
Japanese
Spanish
(10 rows)

language iso field (metadata_field_id = 38)

Total count:
sql: select count( text_value) from metadatavalue where metadata_field_id=38;
Count: 41971
select DISTINCT text_value from metadatavalue where metadata_field_id=38 ;
af
da
de
Dutch
en
en_US
es
fr
French
it
nl
other
sp
SP
Spanish
zh
(16 rows)
Clearly some non-iso values have slipped in.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)