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>
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