Re: [GENERAL] How to quote the COALESCE function?

2016-03-29 Thread Roman Scherer
Tom, Jerry, I'm going to do the same as the `quote_identifier` function of Postgres does, only quote if necessary. Thanks for your explanation, Roman. On Tue, Mar 29, 2016 at 1:31 AM, Jerry Sievers wrote: > Roman Scherer writes: > > > Hello, > > > > I'm bui

[GENERAL] How to quote the COALESCE function?

2016-03-28 Thread Roman Scherer
Hello, I'm building a DSL in Clojure for SQL and specifically PostgreSQL [1]. When building a SQL statement that contains a function call I always quote the function name with \" in case the function name contains any special characters. Here's an example: (select db ['(upper "x")]) ;=> ["SEL