| From: | Dimitri <dimitri(at)France(dot)Sun(dot)COM> |
|---|---|
| To: | "Krasnow, Greg" <gak(at)hnc(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Select MIN() & MAX() |
| Date: | 1998-08-12 19:25:40 |
| Message-ID: | 9808122128520G.00535@dimitri |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 12 Aug 1998, you wrote:
>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)"?
Of course:
insert into t1
select 'a', 'b', min(f) - 1
from t2;
it's standard SQL
>
>- Greg
>
>Greg Krasnow
>HNC Software Inc.
>Financial Solutions Group
>Senior Software Engineer
>Email: gak(at)hnc(dot)com
>Direct Phone: 619.799.8341
>Fax: 619.799.8036
--
=====================================================
Dimitri KRAVTCHUK (dim) Sun Microsystems
Benchmark Engineer France
dimitri(at)France(dot)Sun(dot)COM
=====================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-08-12 19:36:36 | Re: [GENERAL] Select MIN() & MAX() |
| Previous Message | Wim Ceulemans | 1998-08-12 18:47:52 | Unique key with nulls and copying databases across computers |