Lorenzo Huerta <lorhuerta@yahoo.com> wrote:
> In postgres when you create a view can you give that view a
> specific range of your table to be displayed and thats it, i assume
> giving a specified number of columns will work but i don't know
> about the data range.
Do you mean something like
create view x
as select ccc, ddd
from y
where ccc between 4711 and 2001
(with ccc beeing a numeric type)?
Ulf
--
======================================================================
%%%%% Ulf Mehlig <ulf.mehlig@uni-bremen.de>
%%%%!%%% Projekt "MADAM" <umehlig@uni-bremen.de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~