On Sat, Jan 14, 2006 at 01:38:52PM -0600, Robert Paulsen wrote: > > SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]' > ORDER BY state ASC LIMIT 1. > > This works as expected. My problem is that I am relying on the collating > sequence of the letters a-z and the desirability of states may not always be > in this order.
How do you determine desirability? You could order by an expression that evaluates to a state's desirability. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
