Thread

1. order by

   Kaj-Michael Lang <milang@tal.org> — 1998-06-11T11:46:46Z

   I have stored IP's in a table using a varchar(15) field. My problem is how
   to make the order by list the IP's the correct order like: 
   
   192.168.1.1
   192.168.1.6
   192.168.1.10
   
   now it sorts them like:
   
   192.168.1.1
   192.168.1.10
   192.168.1.6
   
   is it possible to get them sorted the right way ?
   
   ------------------------------------------------------------------------------
   Kaj-Michael Lang		milang@tal.org
   Kaskentie 5 C9			http://www.tal.org/
   20720 Turku			ftp://ftp.tal.org/
   FINLAND				klang@abo.fi
   ------------------------------------------------------------------------------
                  Keyboard not found - press any key to continue
   ------------------------------------------------------------------------------
   
   
   

2. Date problems

   Cho Yan Wong <pwong@pobox.leidenuniv.nl> — 1998-06-11T12:28:12Z

   Hello,
   
     I have some problems entering date fields.
   Wether I do:
   
   copy Photographer from 'mydir/db.txt' using delimiters ';';
   
   or insert into Photographer values (1,2,'12-07-1974');
   
   All dates are messed up. The month and day fields are ok, but the year
   value changes to something weird like 32768, 26673 or similarly large
   numbers. Everything else seems to be fine. Any ideas?
   
   How do I manipulate date fields. I;ve tried:
   
   select extract(Year from Birth) from Photographer;
   
   but that doesn't seem to work. I'm using PSQL 6.0 on IRIX6. Any help is
   appreciated.
   
     Tempest
   
   
   

3. Re: [GENERAL] order by

   Oleg Broytmann <phd@comus.ru> — 1998-06-11T12:52:42Z

   Hello!
   
   On Thu, 11 Jun 1998, Kaj-Michael Lang wrote:
   > I have stored IP's in a table using a varchar(15) field. My problem is how
   
      Relcom (Russian Moscow ISP) developed IP type for Postgres:
         http://relcom.eu.net/ipaddr.html
   
   Oleg.
   ---- 
     Oleg Broytmann     http://members.tripod.com/~phd2/     phd2@earthling.net
              Programmers don't die, they just GOSUB without RETURN.
   
   
   

4. Re: [GENERAL] order by

   dave madden <dhm@paradigm.webvision.com> — 1998-06-11T17:09:23Z

    =>From: Kaj-Michael Lang <milang@tal.org>
    =>...
    =>I have stored IP's in a table using a varchar(15) field. My problem is how
    =>to make the order by list the IP's the correct order like: 
    =>
    =>192.168.1.1
    =>192.168.1.6
    =>192.168.1.10
    =>
    =>now it sorts them like:
    =>
    =>192.168.1.1
    =>192.168.1.10
    =>192.168.1.6
    =>
    =>is it possible to get them sorted the right way ?
   
   There may be a special function (or you could write one) to sort
   numbers which are represented as varchars, but a better solution would
   be to re-store the IP numbers as integers.  This will also allow you
   to work on them with netmasks and so forth.  Convert them back to
   A.B.C.D when you print them out.
   
   d.
   
   

5. Re: [GENERAL] order by

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-06-11T17:31:57Z

   > 
   > There may be a special function (or you could write one) to sort
   > numbers which are represented as varchars, but a better solution would
   > be to re-store the IP numbers as integers.  This will also allow you
   > to work on them with netmasks and so forth.  Convert them back to
   > A.B.C.D when you print them out.
   > 
   
   See contrib/ip_and_mac.
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
     +  If your life is a hard drive,     |  (610) 353-9879(w)
     +  Christ can be your backup.        |  (610) 853-3000(h)