substring odd behavior

From: "Regina Obe" <lr(at)pcorp(dot)us>
To: <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: substring odd behavior
Date: 2022-01-28 02:22:14
Message-ID: 001501d813ed$de12a390$9a37eab0$@pcorp.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is this intentional behavior?

-- I can do this
SELECT substring('3.2.0' from '[0-9]*\.([0-9]*)\.');

-- But can't do this gives error syntax error at or near "from"
SELECT pg_catalog.substring('3.2.0' from '[0-9]*\.([0-9]*)\.');

-- but can do
SELECT pg_catalog.substring('3.2.0', '[0-9]*\.([0-9]*)\.');

Thanks,
Regina

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2022-01-28 02:27:39 Re: pg_log_backend_memory_contexts() and log level
Previous Message Kyotaro Horiguchi 2022-01-28 02:10:36 Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?