substring odd behavior - Mailing list pgsql-hackers

From Regina Obe
Subject substring odd behavior
Date
Msg-id 001501d813ed$de12a390$9a37eab0$@pcorp.us
Whole thread Raw
Responses Re: substring odd behavior
List 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




pgsql-hackers by date:

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