Skip to content

explicit_layer regex #12

@sttawm

Description

@sttawm

Seems like the number regex for explicit_layer should be converted from:

1: E'^-?[[:digit:]]+(\.[[:digit:]]+)?$'

to

2: E'^-?[[:digit:]]+(\\.[[:digit:]]+)?$'.

(unless the views are somehow executed in a context that does not require escaped backslashes?)

To test:

``select (CASE WHEN f ~ E'^-?[[:digit:]]+(.[[:digit:]]+)?$' THEN CAST (f AS FLOAT) else 0 END) as ff from (select '1;3'::text as f) as foo`

and

select (CASE WHEN f ~ E'^-?[[:digit:]]+(\\.[[:digit:]]+)?$' THEN CAST (f AS FLOAT) else 0 END) as ff from (select '1;3'::text as f) as foo;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions