Received: from monk.via.net (monk.via.net [209.81.2.10]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAN9gXm31380 for ; Fri, 23 Nov 2001 04:42:33 -0500 (EST) (envelope-from joe@monk.via.net) Received: (from joe@localhost) by monk.via.net (8.11.1/8.11.0) id fAN9iuS32242 for pgsql-sql@postgresql.org; Fri, 23 Nov 2001 01:44:56 -0800 (PST) (envelope-from joe) Date: Fri, 23 Nov 2001 01:44:56 -0800 (PST) From: Joe McGuckin Message-Id: <200111230944.fAN9iuS32242@monk.via.net> To: pgsql-sql@postgresql.org Subject: How to find missing values in a sequence ? X-Archive-Number: 200111/340 X-Sequence-Number: 5722 Assume I have a column that is of type int, whats the easiest way to find the missing values within a specified range ? Thanks, Joe