On Wed, Oct 30, 2019 at 11:12 AM Richard Hipp wrote:
> [...] But using a VIRTUAL generated column as a PRIMARY KEY would be an
> issue.
>
FWIW, I depend on this feature in Oracle, and it works. Both my PRIMARY and
FOREIGN keys
are VIRTUAL columns, which combine two stored columns. Oracle even
On 2019-10-30 12:52 p.m., Keith Medcalf wrote:
On Wednesday, 30 October, 2019 13:23, Darren Duncan
wrote:
On 2019-10-30 12:02 p.m., Simon Slavin wrote:
On 30 Oct 2019, at 6:56pm, Darren Duncan wrote:
"Generated columns may not be used as part of the PRIMARY KEY. (Future
versions of
On Wednesday, 30 October, 2019 13:23, Darren Duncan
wrote:
>On 2019-10-30 12:02 p.m., Simon Slavin wrote:
>> On 30 Oct 2019, at 6:56pm, Darren Duncan wrote:
>>> "Generated columns may not be used as part of the PRIMARY KEY. (Future
>>> versions of SQLite might relax this constraint for
On 2019-10-30 12:02 p.m., Simon Slavin wrote:
On 30 Oct 2019, at 6:56pm, Darren Duncan wrote:
"Generated columns may not be used as part of the PRIMARY KEY. (Future versions of
SQLite might relax this constraint for STORED columns.)"
Replace with this:
"VIRTUAL generated columns may not be
On 30 Oct 2019, at 6:56pm, Darren Duncan wrote:
> "Generated columns may not be used as part of the PRIMARY KEY. (Future
> versions of SQLite might relax this constraint for STORED columns.)"
>
> Replace with this:
>
> "VIRTUAL generated columns may not be used as part of the PRIMARY KEY."
On 2019-10-30 3:12 a.m., Richard Hipp wrote:
On 10/30/19, Darren Duncan wrote:
Ideally a PRIMARY KEY would have no restrictions that a UNIQUE constraint
lacks;
they are conceptually the same thing, a subset of the columns of the row
that
uniquely identifies the row in the table, and
On 10/30/19, Darren Duncan wrote:
>
> Ideally a PRIMARY KEY would have no restrictions that a UNIQUE constraint
> lacks;
> they are conceptually the same thing, a subset of the columns of the row
> that
> uniquely identifies the row in the table, and designating one as PRIMARY is
> completely
Per https://www.sqlite.org/draft/gencol.html thank you very much for adding this
generated columns feature!
I consider this to be a very powerful foundation for a variety of useful
features, in particular because it empowers generalized solutions to several
classes of problem.
In
8 matches
Mail list logo
