Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9dqS-0007i2-QK for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Oct 2017 21:13:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e9dqR-0002NK-KD for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Oct 2017 21:13:11 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e9dor-0005Sj-8K for pgsql-hackers@postgresql.org; Tue, 31 Oct 2017 21:11:33 +0000 Received: from mail-wm0-x22e.google.com ([2a00:1450:400c:c09::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e9doj-0007Fm-Oe for pgsql-hackers@postgresql.org; Tue, 31 Oct 2017 21:11:32 +0000 Received: by mail-wm0-x22e.google.com with SMTP id r196so1415206wmf.2 for ; Tue, 31 Oct 2017 14:11:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=ZlicJl8iisQ27CaUdkn9MG14E6XYtkRpvcKOLBFg5CU=; b=mB4FTmWBXtzlDgjTWbLejewiNjQZ3PyPpvveg6QjZg5eV4ZeZhKloGjRrA0mzK7Gl+ RB77JE0zJDZ0M0FujlSyKCNEMXUmGQFpdLNDaactMvG0N1seFLE/jNSO/62RhPYuJNq3 mskjWpJBrs+6WYMO19AL9Nx9z71U/Y2x1qf/QtlOSwoQaMos8GcVVXhMBbXVgiA9uXwN SPtF4bFgeTtd0is6/KTdcYZmB+UCGxZkQ98sPlacuUK6nGC10iszc6VoTbzq0R8gdS8r gp7LRYW1j/clI2+BR77u7dZNcib/XTINDJIGr0arroZsN2ShVzFKEz8Iu6tO04oZsYpN J1Ow== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=ZlicJl8iisQ27CaUdkn9MG14E6XYtkRpvcKOLBFg5CU=; b=tLKnHm4y+9aKmZx077kg7Z2cvSQD4djGytNePuJZxmCCpNWLHC/ChHyaPcY3y7rbG1 LMnVygp874SPcTVxN5Wv16SJbvj0xu+lzzWqh+qHHgxN4WzNIm1dOHMQolbgO7VEfrGK 1jIPTjeYdVSHSfpFPDbUK89Fx3duBHJAAH4QWyU+cH7qUvOhlfoztNEULBGEKEHRz4z/ oTHzcnakvwgxNb0G4vl/2penhWkF1pg6LyFjO1LLZcMwQr32Rza+q/TI0nJiN6XvMc3o LlAmz1i5JFmBu4fbvEWmSViilQqJaUKYBoOm94+ZrUGO6z2yu55So6ViXFMqh9kujLbV nYqA== X-Gm-Message-State: AMCzsaWLZx0Ql6+fnWP5ahF1+FIbL4ZHqAXN+qjvWGxJpsdevbN2QCRY jXn+YMcx3UODSHSVoSZw6z/a3gV4P4eUQhi1wdQ= X-Google-Smtp-Source: ABhQp+S1Wc6l0lHFJJRlxhLdoA+FiG8+QiemqZGL7aKAuNKUoN22XVkfqIN/Q8v8l3OXPLamljAu4pu5nJnl6b9r6aY= X-Received: by 10.28.48.150 with SMTP id w144mr2812838wmw.23.1509484284220; Tue, 31 Oct 2017 14:11:24 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.146.7 with HTTP; Tue, 31 Oct 2017 14:10:43 -0700 (PDT) In-Reply-To: <5665be80-1772-4998-8dbc-3bd071c0d9ad@rielau.com> References: <20171026220732.GI4496@localhost> <1509399760322-0.post@n3.nabble.com> <5665be80-1772-4998-8dbc-3bd071c0d9ad@rielau.com> From: Pavel Stehule Date: Tue, 31 Oct 2017 22:10:43 +0100 Message-ID: Subject: Re: proposal: schema variables To: Serge Rielau Cc: PostgreSQL Hackers Content-Type: multipart/alternative; boundary="001a1142427e8e1da4055cde32b9" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --001a1142427e8e1da4055cde32b9 Content-Type: text/plain; charset="UTF-8" 2017-10-31 22:08 GMT+01:00 Serge Rielau : > Pavel, > > I can imagine, so DECLARE command will be introduced as short cut for > CREATE TEMP VARIABLE, but in this moment I would not to open this topic. I > afraid of bikeshedding and I hope so CREATE TEMP VAR is anough. > > Language is important because language stays. > You choice of syntax will outlive your code and possibly yourself. > sure. But in this moment I don't see difference between DECLARE VARIABLE and CREATE TEMP VARIABLE different than "TEMP" keyword. Regards Pavel > My 2 cents > Serge > --001a1142427e8e1da4055cde32b9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


2017-10-31 22:08 GMT+01:00 Serge Rielau <serge@rielau.com>:
<= /div>
P= avel,=C2=A0
I can imagine, so= =20 DECLARE command will be introduced as short cut for CREATE TEMP VARIABLE,= =20 but in this moment I would not to open this topic. I afraid of bikeshedding= =20 and I hope so CREATE TEMP VAR is=20 anough.
Language is important because language=20 stays.=C2=A0
You cho= ice of syntax will=20 outlive your code and possibly yourself.

sure. But in this moment I don't see differ= ence between DECLARE VARIABLE and CREATE TEMP VARIABLE different than "= ;TEMP" keyword.

Regards

<= div>Pavel


My 2=20 cents
Serge=C2=A0

--001a1142427e8e1da4055cde32b9--