Postgres Pro
Downloads
Home   >   mailing lists

How to max() make null as biggest value? - Mailing list pgsql-sql

From Feixiong Li
Subject How to max() make null as biggest value?
Date
Msg-id 2A8BBCA2-814C-4E8D-BCE1-11FA2F8D120E@gmail.com
Whole thread Raw
Responses Re: How to max() make null as biggest value?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: How to max() make null as biggest value?  (silly sad <sad@bankir.ru>)
List pgsql-sql
Tree view 
Hi , guys ,
I am newbie for sql, I have a problem when using max() function, I  
need get null when there are null in the value list, or return the  
largest value as usual, who can do this?

i.e.  max([1,2,3,4,5]) => 5
max([1,2,3,4,5,null]) => null

thanks in advance!

Feixiong
feixiongli@gmail.com

pgsql-sql by date:

Previous
From: Steve Lefevre
Date:
Subject: creating a versioning system for sets?
Next
From: Gonzalo Aguilar Delgado
Date:
Subject: Problem with insert related to different schemas