Home > mailing lists

How to find missing values in a sequence ? - Mailing list pgsql-sql

From	Joe McGuckin
Subject	How to find missing values in a sequence ?
Date	November 23, 2001 11:31:35
Msg-id	200111230944.fAN9iuS32242@monk.via.net Whole thread Raw
List	pgsql-sql

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

From: "Johnny J\xF8rgensen"
Date: 23 November 2001, 11:02:40
Subject: Re: How to return more than one row of data from a

From: lcampos@ics.uci.edu (Luis Miguel Campos)
Date: 23 November 2001, 11:31:37
Subject: primary/foreigner keys