I suspect you are missing the GROUP BY part of aggregate SELECT
statements. (MAX is an aggregate function like SUM)
e.g. SELECT MAX(xmin) from userstable GROUP BY whatever
"zammon@libero.it" wrote:
>
> Hi all,
>
> I'm trying to use the xmin column to use it as a versioning row to check
> if the row was modified by
> other users while I edit it.
> I need to select max(xmin) of a group of rows but pg get me an error.
> Someone can give me some tips how to create a funcion MAX(xmin)?
> Thank you
> Jose
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
This is the identity that I use for NewsGroups. Email to
this will just sit there. If you wish to email me replace
the domain with knightpiesold . co . uk (no spaces).