On 07/14/18 20:09, E.Pasma wrote:
The new example is clear, and therefore also raises a question:
CREATE TABLE people (name, age);
INSERT INTO people VALUES ('Bob', 33), ('Jen', 19), ('Liz', 30);
CREATE VIEW older PARAMETERS (name, otherName) AS
SELECT t1.age > t2.age AS older
FROM people
On 19/07/2018 15:53, R Smith wrote:
On 2018/07/19 2:32 PM, Christian Duta wrote:
WITH RECURSIVE
count_down(v) AS (
SELECT 5
UNION ALL
SELECT cd.v - 1
FROM (
SELECT cd.v
FROM count_down AS cd
) AS cd
WHERE cd.v > 0
)
SELECT * FROM count_down;
Error:
On 2018/07/19 2:32 PM, Christian Duta wrote:
WITH RECURSIVE
count_down(v) AS (
SELECT 5
UNION ALL
SELECT cd.v - 1
FROM (
SELECT cd.v
FROM count_down AS cd
) AS cd
WHERE cd.v > 0
)
SELECT * FROM count_down;
Error: near line 1: recursive reference in a
Hello,
when writing a recursive queries, I encountered the following error:
[...] recursive reference in a subquery: [...]
The following minimal example illustrates when this error occurs:
WITH RECURSIVE
count_down(v) AS (
SELECT 5
UNION ALL
SELECT cd.v - 1
FROM (
2018-07-19 11:37 GMT+02:00 R Smith :
> On 2018/07/19 8:35 AM, Cecil Westerhof wrote:
>
>> I have the following Tcl code:
>> set rollback "
>> INSERT OR REPLACE INTO pipRollback
>> (pipType, package, old, new)
>> VALUES
>> (:pip, :package, :old, :new)"
>>
>> db eval
On 2018/07/19 8:35 AM, Cecil Westerhof wrote:
I have the following Tcl code:
set rollback "
INSERT OR REPLACE INTO pipRollback
(pipType, package, old, new)
VALUES
(:pip, :package, :old, :new)"
db eval {BEGIN TRANSACTION}
foreach verbose ${packagesVerbose} {
I have the following Tcl code:
set rollback "
INSERT OR REPLACE INTO pipRollback
(pipType, package, old, new)
VALUES
(:pip, :package, :old, :new)"
db eval {BEGIN TRANSACTION}
foreach verbose ${packagesVerbose} {
.
.
.
if {${doAppend}} {
7 matches
Mail list logo