Re: [GENERAL] question on views... - Mailing list pgsql-general

From Lorenzo Huerta
Subject Re: [GENERAL] question on views...
Date
Msg-id Pine.SOL.3.96.981030013254.27098B-100000@wilma
Whole thread Raw
In response to Re: [GENERAL] question on views...  (Ulf Mehlig <umehlig@uni-bremen.de>)
List pgsql-general
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                       *
     __________________________________________________________________


pgsql-general by date:

Previous
From: Ulf Mehlig
Date:
Subject: Re: [GENERAL] question on views...
Next
From: Memphisto
Date:
Subject: Problem with aggregates and group by