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

From Paul Tomblin
Subject Re: Re: BETWEEN clause
Date
Msg-id 20010424075017.D27707@allhats.xcski.com
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
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.

--
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
"Nobody can be told what the dominatrix is, they have to see it for themselves"

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: Var substitution in SELECT statements
Next
From: Tony Grant
Date:
Subject: Strange locale goings on