On Wed, Jan 21, 2009 at 12:22:14PM -0500, Raymond C. Rodgers wrote: > test=# select * from coordtest where latitude between 42.0 and 42.5 ;
The LHS value of a BETWEEN operator has to be of smaller value than the RHS's value. You've got it correct above, but it's not correct here: > test=# select * from coordtest where longitude between -83.0 and -84.0; -83 is greater than -84. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
