Home > mailing lists

INSERT/SELECT with ORDER BY and LIMIT in 7.1? - Mailing list pgsql-hackers

From	Dirk Lutzebaeck
Subject	INSERT/SELECT with ORDER BY and LIMIT in 7.1?
Date	March 29, 2001 13:32:28
Msg-id	15043.21854.392912.570713@ampato.core.aeccom.com Whole thread Raw
Responses	Re: INSERT/SELECT with ORDER BY and LIMIT in 7.1? ("Oliver Elphick" <olly@lfix.co.uk>)
List	pgsql-hackers

INSERT INTO t1 SELECT a FROM t2 ORDER BY a LIMIT 10;

Is it possible in 7.1?

Dirk

From: Bruce Momjian
Date: 29 March 2001, 11:46:41
Subject: Re: Re: pgmonitor and Solaris

From: Tom Lane
Date: 29 March 2001, 14:21:27
Subject: Re: Problem with group by in conjuction with Views