How to find missing values in a sequence ?

From: Joe McGuckin <joe(at)monk(dot)via(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to find missing values in a sequence ?
Date: 2001-11-23 09:44:56
Message-ID: 200111230944.fAN9iuS32242@monk.via.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Dino Cherian 2001-11-23 12:20:43 Re: How to return more than one row of data from a function in PL/pgSQL
Previous Message Gurudutt 2001-11-23 08:11:43 Re: Joins~ - Thanks a lot~