use Perl

• what does the schema look like? (Score:2)

  by wickline (135)

  > according to PostgreSQL '1000 >= 995' is false.
  
  Is that field a string type rather than a numeric type, by any chance?
  • Re:what does the schema look like? (Score:2)

    by barbie (2653)

    No it's numeric. The 1000 <= 1005 line works fine.
    • Re:what does the schema look like? (Score:1)

      by Wallie (4036) <useperl@vanderwal.xs4all.nl> on 2005.08.15 12:05 (#42630)

      When doing a string compare 1000 <= 1005 would be true but 1000 >= 995 would be false (because 1 is less than 9). So if you're saying it's numeric because '1000 <= 1005 works fine' then you might want to take a look at the table definition. If not then it's a really strange problem, and I would like to know what caused it... if you ever find out.

      Reply to This

      Parent

      • Re:what does the schema look like? (Score:2)

        by barbie (2653)

        Sorry I see the confusion. I have assumed the field to be numeric, as that appears to be how it was set up by the tests in CGI::Wiki::Plugin::Locator::UK [cpan.org]. Although having said that, maybe you're right, perhaps it did create a string field and not a numeric one. That would seem to make sense.