3 ms·
An example of extending your reserved list would be the world "lateral" (new type of join in 9.4). I'll do a PR if I get that far:} RE: comments, yes it would
by qooleot 12y ago
An example of extending your reserved list would be the world "lateral" (new type of join in 9.4). I'll do a PR if I get that far:}
RE: comments, yes it would be quoted and that would cause an error.
select/comment/ 1;
?column?
----------
1
(1 row)
# "select/comment/" 1;
ERROR: syntax error at or near ""select/comment/""
LINE 1: "select/comment/" 1;
That's probably a silly example, and I was just trying to think through 'what could go wrong with this?' before implementing. Thinking about it further, thats probably not something you want the library to be responsible for handling. I'd want to try out newline chars too since thats more common.
- rpedela 12y agoYeah I do need to go through the list of supported SQL keywords for 9.4 and update the library. Thanks for the reminder. The main goal of the library is to behave like Postgres format() plus some JS sugar like handling an array of identifiers. If the library behaviour deviates from Postgres format() then it is a bug. BTW I personally like the %I${var} syntax you mentioned earlier.