On Fri, 30 Oct 1998, Ulf Mehlig wrote:
> Date: Fri, 30 Oct 1998 08:04:57 +0100
> From: Ulf Mehlig <umehlig@uni-bremen.de>
> To: lorhuerta@yahoo.com
> Cc: pgsql-general@postgreSQL.org, lorenzo@nmsu.edu
> Subject: Re: [GENERAL] question on views...
>
> 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
actually you can try having this statement:
where ccc > 2001 and ccc < 4711
>
> (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
> ~~~~~~~~~~~~~~~~~~~~
>
Thanks,
__________________________________________________________________
* Lorenzo J. Huerta *
* Programming Assistant *
* Computing & Networking Networking Architecture and Operations *
* New Mexico State University *
* phone: (w)(505)646-2582 (h)(505) 521-8699 fax:(505) 646-8139 *
* e-mail: lorenzo@nmsu.edu *
* Web Site: http://web.nmsu.edu/~ljhuerta *
__________________________________________________________________