Re: Re: BETWEEN clause

From: Paul Tomblin <ptomblin(at)xcski(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: BETWEEN clause
Date: 2001-04-24 11:50:17
Message-ID: 20010424075017.D27707@allhats.xcski.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Quoting will trillich (will(at)serensoft(dot)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(at)scw(dot)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(at)xcski(dot)com>, not speaking for anybody
"Nobody can be told what the dominatrix is, they have to see it for themselves"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2001-04-24 12:46:36 Strange locale goings on
Previous Message Konstantin Borchert 2001-04-24 08:20:56 Problem with postgreSQL (number of backends)

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2001-04-24 13:33:48 Re: Re: BETWEEN clause
Previous Message will trillich 2001-04-24 07:08:50 Re: Re: BETWEEN clause