use Perl

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

  by wickline (135) on 2005.08.15 9:59 (#42625) Journal

  > according to PostgreSQL '1000 >= 995' is false.
  
  Is that field a string type rather than a numeric type, by any chance?

  Reply to This

  • 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)

      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.
      • 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.