Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glPX6-0006PL-Ow for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Jan 2019 02:41:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glPX5-0002Q0-E5 for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Jan 2019 02:41:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glPX4-0002Ls-Rr for pgsql-hackers@lists.postgresql.org; Mon, 21 Jan 2019 02:41:51 +0000 Received: from bay.acenet.us ([173.230.252.50]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glPX2-0007yK-I4 for pgsql-hackers@lists.postgresql.org; Mon, 21 Jan 2019 02:41:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:Cc:References:To:Subject:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=22mje5kycwUpFiUcRqhXPmWXC2jpT7wEaBse9+o2104=; b=ilxB86r22af57Eb4nGBSTe9Zgu 2ld8E4/+/Cm+dY1Ou8BjyRh85ax69elAsHnSqAXWBkPiufYq/rRTeKEuOhumDnCrfOS56+Lm1gr9H HO4cn8aEBxcLzV5FBE4C1Qk9QUubQkfbn5JMw+BrM53Ou/ubGshwPYhWBMOEvYFVNhmDqx0dihYG+ krcohR4FXtuKYB+CLXn/xFan3J7SJ6w2Ionq5W9wiAq8zOcpghxz/YKjfLbzRfOwOFweeblmCz/WP WbPlp/g8Vd7yJi7RFWrv9s1lH2LCXcncXUx2GKCSlDXE5EZgUadEoyujLp+yQwFCI/ThqwU/kJPzZ N3T2b4PQ==; Received: from [192.182.57.242] (port=50538) by bay.acenet.us with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.91) (envelope-from ) id 1glPWz-000ABQ-Bw; Sun, 20 Jan 2019 21:41:46 -0500 Subject: Re: PostgreSQL vs SQL/XML Standards To: Pavel Stehule References: <5C283168.8060001@anastigmatix.net> <5C291741.9060506@anastigmatix.net> <5C297BB7.9070509@anastigmatix.net> <5C3A7A90.3070207@anastigmatix.net> <5C43FAEB.2070000@anastigmatix.net> <5C4401BE.4080606@anastigmatix.net> <5C449C71.7060903@anastigmatix.net> <5C44B332.6070609@anastigmatix.net> <5C44F26D.5010703@anastigmatix.net> <5C451B39.90307@anastigmatix.net> Cc: PostgreSQL Hackers From: Chapman Flack Message-ID: <5C453168.9020203@anastigmatix.net> Date: Sun, 20 Jan 2019 21:41:44 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: <5C451B39.90307@anastigmatix.net> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-99.5 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - lists.postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap@anastigmatix.net X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 01/20/19 20:07, Chapman Flack wrote: > So it appears that this example does not depend on any special treatment > of the default_expression. > > Is there an example that can be constructed that would depend on the > special treatment (in which case, the PL/Java implementation would be > unable to produce the same result)? I see that I briefly forgot one difference that does matter, namely the timing of a call to a volatile function like nextval. That detail certainly needs to remain in the docs. I am left wondering if that might be the only effect of the deferred argument evaluation that really does matter. Regards, -Chap