Thread: RE: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query?

Is this what you're looking for?

\do

this one eluded me for some time:)

Charles




---Greg Youngblood <YoungblG@houstoncellular.com> wrote:
>
> Many many thanks.. This is exactly what I was looking for.
>
> I must be totally blind... Where can I find a list of the functions
Postgres
> already has.. I'm sure there has to be a way..
>
>
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query?

From
Bruce Momjian
Date:
> Is this what you're looking for?
>
> \do
>
> this one eluded me for some time:)
>
> Charles

Please tell me why it was hard to find, and how to better document it.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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

Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query?

From
"Roderick A. Anderson"
Date:
On Thu, 3 Dec 1998, Bruce Momjian wrote:

> Please tell me why it was hard to find, and how to better document it.

Probably because it scrolls off the top of a standard 24 row screen when
the \? is used.  Or at least on my 6.3.x system at home.  Can't imagine
the command list getting shorter in 6.4 ;-)  Maybe the \? command could
page the display?

Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814


Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query?

From
Bruce Momjian
Date:
> On Thu, 3 Dec 1998, Bruce Momjian wrote:
>
> > Please tell me why it was hard to find, and how to better document it.
>
> Probably because it scrolls off the top of a standard 24 row screen when
> the \? is used.  Or at least on my 6.3.x system at home.  Can't imagine
> the command list getting shorter in 6.4 ;-)  Maybe the \? command could
> page the display?

It does page display here.  Do you have the environment variable PAGER
defined?


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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

Re: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query?

From
"Roderick A. Anderson"
Date:
On Fri, 4 Dec 1998, Bruce Momjian wrote:

> It does page display here.  Do you have the environment variable PAGER
> defined?

Gently pointed out to me earlier today.  No I don't.  I don't get to play
(work) with PostgreSQL as much as I'd like to so this fell out of my short
term memory unit.  It will come in handy when I get back to work on a
couple of projects.
   Sounds like we're running out of excuses for missing the '\do' ;-)  I
didn't have a problem finding it when I've been exploring PostgreSQL but
then I'm very observant (or AR if you believe my wife).

Rod
>
>
> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@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
>

--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814