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

(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
  ~~~~~~~~~~~~~~~~~~~~