(format nil " (~d)" length)
"")))
((:postgresql :postgresql-socket)
+ ;; FIXME: incorrect syntax
(if (integerp length)
- (format nil "substr(~A,1,~D)" colname length)
+ (format nil "substr((~A)::text,1,~D)" colname length)
colname))
(t
colname))))
(defun drop-index-cmd (colname tablename)
"Return sql create index command"
- (case *umls-sql-type
+ (case *umls-sql-type*
(:mysql
(format nil "DROP INDEX ~a ON ~a"
(concatenate 'string tablename "_" colname "_X")
(defun sql-create-indexes (conn &optional (indexes +index-cols+))
"SQL Databases: create all indexes"
(dolist (idx indexes)
- (ignore-errors
- (sql-execute (drop-index-cmd (car idx) (cadr idx)) conn))
+ (ignore-errors (sql-execute (drop-index-cmd (car idx) (cadr idx)) conn))
(sql-execute (create-index-cmd (car idx) (cadr idx) (caddr idx)) conn)))
(defun make-usrl (conn)
("SUI" "MRCON") ("CUI" "MRCXT") ("CUI" "MRDEF") ("CUI" "MRLO")
("CUI1" "MRREL") ("CUI" "MRSAT") ("LUI" "MRSAT") ("SUI" "MRSAT")
("CUI" "MRSO") ("SAB" "MRSO") ("SRL" "MRSO") ("CUI" "MRSTY")
- ("TUI" "MRSTY") ("CUI" "MRXNS_ENG") ("NSTR" "MRXNS_ENG" 10)
+ ("TUI" "MRSTY") ("CUI" "MRXNS_ENG")
+ #+ignore ("NSTR" "MRXNS_ENG" 10)
("CUI" "MRXNW_ENG") ("NWD" "MRXNW_ENG") ("WD" "MRXW_ENG")
("KCUISUI" "MRCON") ("KCUILUI" "MRCON") ("KCUILRL" "MRCON")
("KLUILRL" "MRCON") ("KCUISUI" "MRCXT")