diff options
| author | Robin Haberkorn <robin.haberkorn@googlemail.com> | 2023-10-06 11:46:27 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-10-06 11:46:27 +0300 |
| commit | 03777f5be657dcaa8fe379f2e1a39d1c2db04d00 (patch) | |
| tree | a93ab944c72bb081633f951ac29af540b02c7c4c | |
| parent | 470373386cf33c3c7359d15a44d82d2d84a7c065 (diff) | |
| parent | 984e555acbadbd1aed7df17ab53e2c586a2f8f68 (diff) | |
| download | openrussian-cli-03777f5be657dcaa8fe379f2e1a39d1c2db04d00.tar.gz | |
Merge pull request #3 from vs49688/master
postprocess: remove use of double-quoted strings
| -rw-r--r-- | postprocess.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/postprocess.sql b/postprocess.sql index 5976cb1..950bb27 100644 --- a/postprocess.sql +++ b/postprocess.sql @@ -18,7 +18,7 @@ CREATE TABLE bare_inflections (`word_id` INTEGER NOT NULL, `bare` VARCHAR(100) N -- also be BINARY collated. See also: -- https://www.sqlite.org/optoverview.html#the_like_optimization CREATE INDEX idx_bare_inflections_bare ON bare_inflections (`bare`); -INSERT INTO bare_inflections SELECT word_id, REPLACE(temp, "'", "") AS bare +INSERT INTO bare_inflections SELECT word_id, REPLACE(temp, '''', '') AS bare FROM ( -- Search word might be a noun or adjective declension SELECT word_id, nom AS temp FROM declensions @@ -72,7 +72,7 @@ FROM ( UNION ALL SELECT word_id, pl3 AS temp FROM conjugations ) -WHERE bare <> ""; +WHERE bare <> ''; -- Saves a few megabytes VACUUM; |