pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chapman Flack <chap@anastigmatix.net>
To: Christoph Berg <myon@debian.org>
To: pgsql-pkg-debian@postgresql.org
Subject: Re: PL/Java 1.5.1
Date: Tue, 16 Oct 2018 08:49:17 -0400
Message-ID: <5BC5DE4D.3070502@anastigmatix.net> (raw)
In-Reply-To: <20181016113214.GA3027@msg.df7cb.de>
References: <20181016113214.GA3027@msg.df7cb.de>

On 10/16/18 07:32, Christoph Berg wrote:

>> 2. You seem to be building packages for PG from 11 back to 9.3. For that
>>    range of PG versions, it would be possible to add the -Psaxon-examples
...
>>    It's actually safe to add -Psaxon-examples when building for any PG
>>    version back to 8.4. Before 8.4, those examples can't be included

> I'm not really following how that relates to the range of PG versions?
> Because it's "only" 8.4+ ?

The saxon-examples functions are declared with SQL syntax that didn't
exist pre-8.4, so they would just be rejected as syntax errors in 8.3
or 8.2.

The documentation illustrating how to call them uses named-parameter
notation with => so it works as far back as 9.5, and with a simple
substitution of := for => they can be called the same way as far back
as 9.0. But the illustrations also show FROM clauses with LATERAL or
with a function referring to earlier entries, which is only possible
in 9.3+.

So the saxon-examples PG version range dependency boils down to:

* the functions can be built and installed in any version 8.4 and up
* they are easy to use in 9.5 and up, following exactly the illustrations
    in the docs
* they are almost as easy to use in 9.3 and 9.4, changing => to :=
* from 9.2 back to 8.4, they work, but require increasing devilish
    cleverness to write SQL queries that use them.

-Chap




view thread (8+ messages)  latest in thread

Message-ID: <5BC5DE4D.3070502@anastigmatix.net>
Permalink:  ../5BC5DE4D.3070502@anastigmatix.net/
Also on:    postgresql.org/message-id/5BC5DE4D.3070502@anastigmatix.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-pkg-debian@postgresql.org
  Cc: chap@anastigmatix.net, myon@debian.org
  Subject: Re: PL/Java 1.5.1
  In-Reply-To: <5BC5DE4D.3070502@anastigmatix.net>
  References: <20181016113214.GA3027@msg.df7cb.de> <5BC5DE4D.3070502@anastigmatix.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox