Re: Re: BETWEEN clause - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Re: BETWEEN clause
Date
Msg-id 200104241927.f3OJRGa10019@candle.pha.pa.us
Whole thread Raw
In response to Re: Re: BETWEEN clause  (will trillich <will@serensoft.com>)
Responses Re: Re: BETWEEN clause
Re: Re: BETWEEN clause
List pgsql-general
If someone can think of a clearer way to present it, we are all ears.

> On Tue, Apr 24, 2001 at 07:50:17AM -0400, Paul Tomblin wrote:
> > Quoting will trillich (will@serensoft.com):
> > > > test=# create view its_really_the_same_thing as select true where 1
> > > > between 1 and 3;
> > > >
> > > > test=# \d its_really_the_same_thing
> > > > ...
> > > > View definition: SELECT 't'::bool WHERE ((1 >= 1) AND (1 <= 3));
> > > >
> > > >
> > > > HTH,
> > > > --
> > > > Joel Burton   <jburton@scw.org>
> > > > Director of Information Systems, Support Center of Washington
> > >
> > > just wanted to say -- BEAUTIFULLY executed reply.
> > > not only did you answer the query succinctly and completely,
> > > you showed, quite clearly, how to find out such answers.
> >
> > I was impressed as well.  I didn't know you could use \d to find the
> > definition of views like that.
>
> i finally figured that one out after my ten-thousandth "\?" where
> i saw \d*:
>
>     [snip]
>     \copyright     show PostgreSQL usage and distribution terms
>     \d <table>     describe table (or view, index, sequence)
>     \d{t|i|s|v}    list tables/indices/sequences/views
>     \d{p|S|l}      list permissions/system tables/lobjects
>     \da            list aggregates
>     \dd [object]   list comment for table, type, function, or operator
>     \df            list functions
>     \do            list operators
>     \dT            list data types
>     [snip]
>
> thus \dv shows views, \dt tables, \di indexes, \ds sequences
>
> altho "\d view_name" shows view definition and "\dv view" shows a
> list of views whose name is LIKE "view%"...
>
> and elsewhere i saw that \d+ would show more info, albeit
> not-much-used comments. (and \dv+ and \di+...)
>
> see "\h comment" for more on comments/descriptions.
> (anybody using those for anything, by the way?)
>
> --
> don't visit this page. it's bad for you. take my expert word for it.
> http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html
>
> will@serensoft.com
> http://sourceforge.net/projects/newbiedoc -- we need your brain!
> http://www.dontUthink.com/ -- your brain needs us!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: IBM to buy Informix
Next
From: will trillich
Date:
Subject: Re: append all columns in where-clause