Re: [GENERAL] minimum function

2007-06-25 Thread Gunther Mayer
Tom Lane wrote: Gunther Mayer <[EMAIL PROTECTED]> writes: SELECT minimum(5,6) => 5 You're looking for the least/greatest functions (in 8.1 and up IIRC). regards, tom lane Awesome, that's exactly what I was looking for. My pl/pgsql minim

[GENERAL] minimum function

2007-06-23 Thread Gunther Mayer
Hi there, I'm busy writing a trigger function in pl/pgsql and find myself in need of a minimum() function. I can't see how the builtin min() aggregate function can be of any use here since all I want to do is something like SELECT minimum(5,6) => 5 Any way I can achieve that on one line? I.e

[GENERAL] Apparent Wraparound?

2007-06-08 Thread Gunther Mayer
Hi there, I just found the following message in my logs: Jun 8 10:38:38 caligula postgres[56868]: [1-1] : LOG: could not truncate directory "pg_subtrans": apparent wraparound Should I be worried or can I just ignore this one? My database is still small (a pg_dumpall bzippe'd is still aroun