----- Original Message ---- > From: Tom Lane <tgl@xxxxxxxxxxxxx> > You could code that directly with CASE > operations, but it would probably > be easier to use GREATEST/LEAST, along the > lines of > new_percentage = LEAST(num_intervals * .1, > 1); Ah, I didn't know about the LEAST function! I love you (platonically, of course. My fiancée might have issues otherwise). Cheers, Ovid -- Buy the book - http://www.oreilly.com/catalog/perlhks/ Tech blog - http://blogs.perl.org/users/ovid/ Twitter - http://twitter.com/OvidPerl Official Perl 6 Wiki - http://www.perlfoundation.org/perl6 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general