Listing Numbers - Mailing list pgsql-general

From Brian Avis
Subject Listing Numbers
Date
Msg-id 3C83F008.1070908@searhc.org
Whole thread Raw
List pgsql-general
If I have a column with a list of numbers between 1 and 9999 is there a
way to select all the numbers in that range that have not been used?

For example lets say the list is 1 - 10 instead, and looked like this.

1
2
3
5
7
9
10


I want the database to return

4
6
8


Any hints or ideas?

--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
cd /pub
more beer



pgsql-general by date:

Previous
From: Hunter Hillegas
Date:
Subject: Changes to NOW() in 7.2?
Next
From: Oliver Elphick
Date:
Subject: Re: SQL statement : list table details