12 Apr
2019
12 Apr
'19
1:12 a.m.
Thank you, it makes perfect sense now. I don't know why I got confused with the pattern matching. Maybe it just looked like casting and I got the types wrong.
In general, you can't use that kind of substitution with SQL Data Definition Language (e.g. CREATE TABLE), nor is it generally usable to replace table or column names, only values. You need to concatenate the actual table name into the command, not a SQL string-like value nor an embedded SQL placeholder.
I didn't know that. Thank you. -- Guy-Laurent Subri