faber4 on irc asked about how to get ascii-based sorting, while his postgresql was initdb'ed with utf-8 based locale (en_US.UTF-8 to be exact). what can we do about it?

luckymurali_81 on freenodes #postgresql had a problem. his query returns data in wrong order. what can we do about it?

mage_ from #postgresql had interesting problem today. he has a table with 2 date fields, and he wants to have list of all years from both fields. together. as one list. his approach: select date_part('year', date1) from test union select date_part('year', date2) from test; is hardly ...