[
https://issues.apache.org/jira/browse/CALCITE-5305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17611755#comment-17611755
]
Dmitry Sysolyatin commented on CALCITE-5305:
--------------------------------------------
[~julianhyde] Do we really need enable mechanism for it ? Can it be enable
always, it does not seem to contradict any dialect.
Also I have added example in description. More examples can be found in tests
https://github.com/apache/calcite/pull/2926
> Support string constants with c-style escapes
> ---------------------------------------------
>
> Key: CALCITE-5305
> URL: https://issues.apache.org/jira/browse/CALCITE-5305
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Dmitry Sysolyatin
> Assignee: Dmitry Sysolyatin
> Priority: Major
>
> Support string constants with c-style escapes. Example:
> {code}
> select e'\u0061\x61\141' as col1;
> col1
> ------
> aaa
> (1 row)
> {code}
> [4.1.2.2. String Constants With C-Style
> Escapes|https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
