On Tue, Mar 29, 2016 at 12:38 PM, Pavel Stehule wrote:
> The coalesce is one few functions implemented by special rule in
> PostgreSQL parser.
In the SQL standard the COALESCE feature is not listed as a
function; it is listed as one of the short forms of CASE
expression. While it has function-l
Hi
2016-03-29 10:30 GMT+02:00 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.
>
The coalesce is one few functions implemented by special rule in PostgreSQL
parser. Some
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 building a DSL in Clojure for SQL and s
Roman Scherer writes:
> 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:
>
> Â
Roman Scherer writes:
> Can someone explain to me what's the difference between quoting
> the `upper` and the `coalesce` function?
COALESCE is a keyword.
> What I found so far is, that the `upper` function can be found in
> the `pg_proc` table but not `coalesce`.
Yup.
> Does this mean that `co
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
