Re: Function in psql to Compare two numbers and return the bigger value

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@noao.edu
The gods that smiled on your birth are now laughing out loud.