Changes

Jump to navigation Jump to search
328 bytes added ,  10:57, 28 July 2016
no edit summary
'Country' is missing.
allpatent_clone=# SELECT COUNT(*) FROM assignees assigneeinfo WHERE country=' ';
count
---------
Leonie M. Brinkema | EDVa | 2
<section end="lexjudge" />
 
===PatentId===
<section begin ="patentid" />
The patentid table has many entries that do not consist of only integers.
 
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[A-Z]';
count
-------
775982
 
 
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]';
count
--------
27294418
<section end="patentid" />

Navigation menu