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 distribu
Emi Lu wrote:
I am looking for a psql method to get the bigger value of two numbers.
For example,
methodName(12.6, 3.8)
select greatest(12.6,3.8);
It does not work for me,
select greatest(12.6,3.8);
ERROR: function greatest(numeric, numeric) does not exist
HINT: No function matches the
I am looking for a psql method to get the bigger value of two numbers.
For example,
methodName(12.6, 3.8)
select greatest(12.6,3.8);
It does not work for me,
select greatest(12.6,3.8);
ERROR: function greatest(numeric, numeric) does not exist
HINT: No function matches the given name and
Emi Lu wrote:
HEllo,
I am looking for a psql method to get the bigger value of two numbers.
For example,
methodName(12.6, 3.8)
select greatest(12.6,3.8);
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropr
ubject: [GENERAL] Function in psql to Compare two numbers and return
the bigger value
HEllo,
I am looking for a psql method to get the bigger value of two numbers.
For example,
methodName(12.6, 3.8)
Will return 12.6
Thanks!
---(end of broadcast)---
HEllo,
I am looking for a psql method to get the bigger value of two numbers.
For example,
methodName(12.6, 3.8)
Will return 12.6
Thanks!
---(end of broadcast)---
TIP 6: explain analyze is your friend
