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.