Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Select MIN() & MAX() - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Select MIN() & MAX()
Date
Msg-id 199808121937.PAA11645@candle.pha.pa.us
Whole thread Raw
In response to Select MIN() & MAX()  ("Krasnow, Greg" <gak@hnc.com>)
List pgsql-general
Tree view 
> oops... my goof... I read it too quickly...
>
> ok... one more stupid question... can you not do an "insert into t1 (select
> 'a','b',min(f)-1 from t2)"?

Do:

insert into t1
select 'a','b',min(f)-1 from t2

I think that should work.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Select MIN() & MAX()
Next
From: Terence Dixon
Date:
Subject: unsubscribe pgsql-general