Is it just me, or is there a problem with the rendering of markdown? Just posted this answer on dba.SE:
Searching for a close numeric match on spatial coordinates
Unlike with other (pre-existing) posts, rendering seems to fail.
asked Dec 31 '20 at 14:36
-
1I see it fine, both in the post and your picture. What is the problem? Can you mark the problematic area somehow, or explain better? – Shadow Wizard is Vaccinating Dec 31 '20 at 14:40
-
@ShadowWizardisVaccinating: Glorfindel helped me to fix a markup error. – Erwin Brandstetter Dec 31 '20 at 14:40
-
But what error? I don't see any problem. – Shadow Wizard is Vaccinating Dec 31 '20 at 14:41
-
1@ShadowWizardisVaccinating I've changed the link to point at the revision with the problem. – Glorfindel Dec 31 '20 at 14:42
Add a comment
|
The problem is this block of code near the end of your post:
```
SELECT *, ((longitude - 9.876543210987654321) ^ 2
+ (latitude - 1.234567890123456789) ^ 2) AS squared_dist
FROM tbl
WHERE ((longitude - 9.876543210987654321) ^ 2
+ (latitude - 1.234567890123456789) ^ 2) < 0.000000001 -- or whatever
ORDER BY point (longitude, latitude)
<-> point '(9.876543210987654321,1.234567890123456789)'
LIMIT 10;
```pgsql
The ```pgsql is not recognized as the end of a code block; the language hint should be at the beginning instead.
answered Dec 31 '20 at 14:39
