Changes between Initial Version and Version 2 of Ticket #5697


Ignore:
Timestamp:
Mar 16, 2024, 12:53:27 AM (8 weeks ago)
Author:
Yuri
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5697 – Description

    initial v2  
    2525
    2626}}}
     27
     28An even more convoluted case (might be better as it covers a few more edge cases):
     29
     30{{{
     31CREATE SCHEMA """Quotes' \ \' \"" and Space.Dot.";
     32
     33CREATE TABLE """Quotes' \ \' \"" and Space.Dot.".". Points"" \ \' \"" 'quote"
     34(
     35    "' id '"                SERIAL PRIMARY KEY,
     36    ".namE "                TEXT,
     37    ". ' \ \' \"" ""Geom""" GEOMETRY(POINT, 4326)
     38);
     39
     40INSERT INTO """Quotes' \ \' \"" and Space.Dot.".". Points"" \ \' \"" 'quote"
     41values (1, '02daedc70702ec68753fde38351f5d9d', '0101000020E610000050C4D38CE9DA61401EFC0EC7C3DA2740'),
     42       (2, '7418427ba8a960c3661235f47cc13d46', '0101000020E6100000CC2F4170E9DA6140DEDB02B581DA2740');
     43
     44CREATE INDEX ON """Quotes' \ \' \"" and Space.Dot.".". Points"" \ \' \"" 'quote" USING GIST (". ' \ \' \"" ""Geom""");
     45}}}