Postgres Pro
Downloads
Home   >   mailing lists

Re: Function in psql to Compare two numbers and return the bigger value - Mailing list pgsql-general

From Adam Rich
Subject Re: Function in psql to Compare two numbers and return the bigger value
Date
Msg-id 007701c74f9f$5ff62630$6400a8c0@dualcore
Whole thread Raw
In response to Function in psql to Compare two numbers and return the bigger value  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Tree view 
You want GREATEST()

<http://www.postgresql.org/docs/8.2/interactive/functions-conditional.ht
ml#AEN13140>


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Emi Lu
Sent: Tuesday, February 13, 2007 12:37 PM
To: pgsql-general@postgresql.org
Subject: [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)---------------------------
TIP 6: explain analyze is your friend

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Function in psql to Compare two numbers and return the bigger value
Next
From: Laura McCord
Date:
Subject: Re: Having a problem with my stored procedure