I'm using this in a an application right now:
$result = pg_Exec($conn, "SELECT MAX(pos) FROM demogallery;");
and its been working fine for about 2-3 months...
On Wed, 12 Aug 1998, Krasnow, Greg wrote:
> In the documentation it mentions that Postgresql does not currently support
> MIN() and M
> In the documentation it mentions that Postgresql does not currently support
> MIN() and MAX() in the select list, but only in the where clause... will
> this be available in the next version of Postgresql and is there another way
> to do this in the current version?
But we do support them in th
> 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 Av
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
>
>G
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)"?
- Greg
Greg Krasnow
HNC Software Inc.
Financial Solutions Group
Senior Software Engineer
Email: [EMAIL PROTECTED]
Direct Phone: 619.799.8341
Fax: 6
On Wed, 12 Aug 1998, you wrote:
>In the documentation it mentions that Postgresql does not currently support
>MIN() and MAX() in the select list, but only in the where clause... will
>this be available in the next version of Postgresql and is there another way
>to do this in the current version
In the documentation it mentions that Postgresql does not currently support
MIN() and MAX() in the select list, but only in the where clause... will
this be available in the next version of Postgresql and is there another way
to do this in the current version?
- Greg
Greg Krasnow
HNC Software I
