From: | Joel Burton <jburton(at)scw(dot)org> |
---|---|
To: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: BETWEEN clause |
Date: | 2001-04-24 13:33:48 |
Message-ID: | Pine.LNX.4.21.0104240931440.11638-100000@olympus.scw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
On Tue, 24 Apr 2001, Paul Tomblin wrote:
> 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.
Yep.
Now what I'd love is \recreate foobar which would execute
DROP VIEW foobar; CREATE VIEW foobar AS ...
So that I could conveniently up-arrow in psql's readline, and edit and
re-create the view.
Woud save me a hundred vi fumblings or X-mouse cutting and pastings a
week.
... who needs GUIs? ;-)
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Keller | 2001-04-24 13:39:32 | indices are crashed after installation of rpm |
Previous Message | Tony Grant | 2001-04-24 12:53:30 | Converting queries to upper case |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Weholt | 2001-04-24 15:53:52 | Storing big chunks of text, variable length |
Previous Message | Paul Tomblin | 2001-04-24 11:50:17 | Re: Re: BETWEEN clause |