diff options
| author | Greg Roach <greg@subaqua.co.uk> | 2021-01-27 09:50:17 +0000 |
|---|---|---|
| committer | Greg Roach <greg@subaqua.co.uk> | 2021-01-27 09:50:17 +0000 |
| commit | cec4277ebf39a5d1aaaf812830ad550a2c32ca0a (patch) | |
| tree | 7db03c7c03bc8f179ce57fd7b5c59c8acb055c7a /app | |
| parent | 040889395b0bfc5a159042577fdfa55fae7928cb (diff) | |
| download | webtrees-cec4277ebf39a5d1aaaf812830ad550a2c32ca0a.tar.gz webtrees-cec4277ebf39a5d1aaaf812830ad550a2c32ca0a.tar.bz2 webtrees-cec4277ebf39a5d1aaaf812830ad550a2c32ca0a.zip | |
Fix: #3693 - Postgres needs explicit cast from string to float
Diffstat (limited to 'app')
| -rw-r--r-- | app/Schema/Migration44.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/Schema/Migration44.php b/app/Schema/Migration44.php index 8c5c440fb1..acbf4346b7 100644 --- a/app/Schema/Migration44.php +++ b/app/Schema/Migration44.php @@ -87,8 +87,8 @@ class Migration44 implements MigrationInterface 'pl_id', new Expression('CASE pl_parent_id WHEN 0 THEN NULL ELSE pl_parent_id END'), 'pl_place', - new Expression("REPLACE(REPLACE(pl_lati, 'S', '-'), 'N', '')"), - new Expression("REPLACE(REPLACE(pl_long, 'W', '-'), 'E', '')"), + new Expression("CAST(REPLACE(REPLACE(pl_lati, 'S', '-'), 'N', '') AS FLOAT)"), + new Expression("CAST(REPLACE(REPLACE(pl_long, 'W', '-'), 'E', '') AS FLOAT)"), ]); DB::table('place_location') |