pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Sergei Kornilov <sk@zsrv.org>
Cc: Jaime Casanova <jaime.casanova@2ndquadrant.com>
Subject: Re: [HACKERS] generated columns
Date: Mon, 1 Apr 2019 10:50:40 +0200
Message-ID: <08631503-db23-2f25-062b-3944a7020609@2ndquadrant.com> (raw)
In-Reply-To: <20190330092416.GO5815@telsasoft.com>
References: <57c70b3e-b29a-ad08-cdce-746f6d561e3d@2ndquadrant.com>
	<20190226053059.GF27822@paquier.xyz>
	<a9dcee31-6ae9-f581-f362-a27774cbe156@2ndquadrant.com>
	<20190227073124.GH3540@paquier.xyz>
	<4ebd3319-43df-94b1-4f5c-4149d8bd0031@2ndquadrant.com>
	<CAFj8pRApJQfre4zpAx+PR0KHazqzgJDEB=hG9hmdzt16xoaprw@mail.gmail.com>
	<20190320025103.GG3488@paquier.xyz>
	<d75e0126-8484-3dd9-0193-aa091299b130@2ndquadrant.com>
	<CAFj8pRD3L9pZqrh-2BuBaBHa2A-h3-xAoO0v2dujwaKtfeS1OQ@mail.gmail.com>
	<24577a1a-0216-3094-2360-1ddb2fc6a100@2ndquadrant.com>
	<20190330092416.GO5815@telsasoft.com>

On 2019-03-30 10:24, Justin Pryzby wrote:
> create_table.sgml now has this:
> 
> https://www.postgresql.org/docs/devel/sql-createtable.html#id-1.9.3.85.6.2.18.1.2
> +     <para>
> +      The keyword <literal>STORED</literal> is required to signify that the
> +      column will be computed on write and will be stored on disk.  default.
> +     </para>
> 
> What does "default." mean ?

Typo, fixed.

> Also, this is working but not documented as valid:
> postgres=# CREATE TABLE t (j int, i int GENERATED BY DEFAULT AS (j*j+1) STORED);

Fixed.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





view thread (112+ messages)  latest in thread

Message-ID: <08631503-db23-2f25-062b-3944a7020609@2ndquadrant.com>
Permalink:  ../08631503-db23-2f25-062b-3944a7020609@2ndquadrant.com/
Also on:    postgresql.org/message-id/08631503-db23-2f25-062b-3944a7020609@2ndquadrant.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: peter.eisentraut@2ndquadrant.com, pryzby@telsasoft.com, pavel.stehule@gmail.com, michael@paquier.xyz, sk@zsrv.org, jaime.casanova@2ndquadrant.com
  Subject: Re: [HACKERS] generated columns
  In-Reply-To: <08631503-db23-2f25-062b-3944a7020609@2ndquadrant.com>

* 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