Re: [BUGS] Relational operators

2005-06-27 Thread Stephan Szabo
On Mon, 27 Jun 2005, Pieter-Jan Savat wrote: > I was wondering if the following issue is in fact a bug, or just > inconvenient behaviour... > > say a table looks like this: > > table > --- > c (varchar) > '20' > '0' > '-10' > 'klj' > '> 5' > 'qwerty' > '< 6' > > The query select * from table where

[BUGS] Relational operators

2005-06-27 Thread Pieter-Jan Savat
Hi, I was wondering if the following issue is in fact a bug, or just inconvenient behaviour... say a table looks like this: table --- c (varchar) '20' '0' '-10' 'klj' '> 5' 'qwerty' '< 6' The query select * from table where c < 5 will return for instance the tuple containing '20'. In other