View for prime numbers

From: Christian Kienert <Christian.Kienert_at_gmx.de>
Date: Fri, 30 Jan 2004 12:02:08 +0100
Message-ID: <bvddiu$94e$1_at_ngspool-d02.news.aol.com>


Hi,

We are just discussing "you can do almost everything using a view". Of course the view might become a large one, but it should be possible to do it with a view.

Any ideas on how to write a view that returns the prime numbers within a table of numbers?

e.g.

	create table NUMBERS (number integer);
	create view PRIMES (number) as ???;
Received on Fri Jan 30 2004 - 12:02:08 CET

Original text of this message