Use of MIN/MAX

[Matthew Painter]

I am trying to do something pretty simple:

UPDATE t SET d=MIN(?,2) where id=?

It fails with "Syntax error in SQL statement". 

Can MIN only be applied to GROUP BY? Is there another operator I am missing?!?

Thanks!

Matt

[Noel Grandin]

Use LEAST
http://h2database.com/html/functions.html#least

[Matthew Painter]

Thank you! :D

On Mon, Aug 19, 2013 at 7:47 PM, Noel Grandin <noelg...@gmail.com> wrote:

Use LEAST
http://h2database.com/html/functions.html#least

--
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/ZWlhgBiznDs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.