Re: [GENERAL] question on views...

On Fri, 30 Oct 1998, Ulf Mehlig wrote:

> Date: Fri, 30 Oct 1998 08:04:57 +0100
> From: Ulf Mehlig <umehlig(at)uni-bremen(dot)de>
> To: lorhuerta(at)yahoo(dot)com
> Cc: pgsql-general(at)postgreSQL(dot)org, lorenzo(at)nmsu(dot)edu
> Subject: Re: [GENERAL] question on views...
>
> Lorenzo Huerta <lorhuerta(at)yahoo(dot)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(dot)mehlig(at)uni-bremen(dot)de>
> %%%%!%%% Projekt "MADAM" <umehlig(at)uni-bremen(dot)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(at)nmsu(dot)edu *
* Web Site: http://web.nmsu.edu/~ljhuerta *
__________________________________________________________________