Emi Lu wrote: > Does it mean it is not allowed to use "select greatest(12.6,3.8)" ? It may mean you're not running 8.1? Here's what I get: ----------------------------------------------------------- ->psql Welcome to psql 8.1.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit swampler=# select GREATEST(6.3, 2.8); greatest ---------- 6.3 (1 row) swampler=# select greatest(6.3, 2.8); greatest ---------- 6.3 (1 row) swampler=# ----------------------------------------------------------- -- Steve Wampler -- swampler@xxxxxxxx The gods that smiled on your birth are now laughing out loud.