Re: [GENERAL] question on views...
От | Lorenzo Huerta |
---|---|
Тема | Re: [GENERAL] question on views... |
Дата | |
Msg-id | Pine.SOL.3.96.981030013254.27098B-100000@wilma обсуждение исходный текст |
Ответ на | Re: [GENERAL] question on views... (Ulf Mehlig <umehlig@uni-bremen.de>) |
Список | 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 по дате отправления: