Re: Max/min of 2 values function, plpgsql efficency? - Mailing list pgsql-general

From Bas Scheffers
Subject Re: Max/min of 2 values function, plpgsql efficency?
Date
Msg-id 1320.217.205.40.94.1078248632.squirrel@io.scheffers.net
Whole thread Raw
In response to Max/min of 2 values function, plpgsql efficency?  ("Karl O. Pinc" <kop@meme.com>)
List pgsql-general
Just use the CASE statment, example:

create table test (foo int, bar int);
insert into test2 values (1, 2);
insert into test2 values (4, 3);

select case when foo > bar then foo else bar end from test2;

Bas.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions)
Next
From: Bruno Wolff III
Date:
Subject: Re: max table size