| 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... |
| Date: | 1998-10-30 07:04:57 |
| Message-ID: | 199810300704.IAA02143@uni-bremen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
(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
~~~~~~~~~~~~~~~~~~~~
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ulf Mehlig | 1998-10-30 07:10:28 | Re: [GENERAL] question on views... |
| Previous Message | The Hermit Hacker | 1998-10-30 02:30:31 | RE: [GENERAL] status |