Home > mailing lists

Re: Insert Data Into Tables Linked by Foreign Key - Mailing list pgsql-general

From	Grzegorz Jaśkiewicz
Subject	Re: Insert Data Into Tables Linked by Foreign Key
Date	January 4, 2010 12:38:26
Msg-id	2f4958ff1001040538r2644adebtf54104a8c834970c@mail.gmail.com Whole thread Raw
In response to	Re: Insert Data Into Tables Linked by Foreign Key ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-general

insert into foo(a) with recursive t(n) AS (SELECT 10 AS n UNION ALL
SELECT n-1 FROM t WHERE n > 0) select n from t;

works on 8.5



--
GJ

From: "A. Kretschmer"
Date: 04 January 2010, 12:23:50
Subject: Re: Insert Data Into Tables Linked by Foreign Key

From: Chris Withers
Date: 04 January 2010, 12:38:36
Subject: Re: how do I disable automatic start on mac os x?