Postgres Pro
Downloads
Home   >   mailing lists

Thread: question on views...

question on views...

From
Lorenzo Huerta
Date:

  Hi all got another question this morning,

   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.


lorenzo


_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: [GENERAL] question on views...

From
Ulf Mehlig
Date:
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
  ~~~~~~~~~~~~~~~~~~~~

Re: [GENERAL] question on views...

From
Lorenzo Huerta
Date:
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                       *
     __________________________________________________________________