Re: [GENERAL] Select MIN() & MAX()

[Bruce Momjian]

> 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
[EMAIL PROTECTED]              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)