1. 24 Jun, 2003 13 commits
    • Bruce Momjian's avatar
    • Bruce Momjian's avatar
      Add ipv6 address parsing support to 'inet' and 'cidr' data types. · 945543d9
      Bruce Momjian authored
              Regression tests for IPv6 operations added.
      
              Documentation updated to document IPv6 bits.
      
              Stop treating IPv4 as an "unsigned int" and IPv6 as an array of
              characters.  Instead, always use the array of characters so we
              can have one function fits all.  This makes bitncmp(), addressOK(),
              and several other functions "just work" on both address families.
      
              add family() function which returns integer 4 or 6 for IPv4 or
              IPv6.  (See examples below)  Note that to add this new function
              you will need to dump/initdb/reload or find the correct magic
              to add the function to the postgresql function catalogs.
      
              IPv4 addresses always sort before IPv6.
      
              On disk we use AF_INET for IPv4, and AF_INET+1 for IPv6 addresses.
              This prevents the need for a dump and reload, but lets IPv6 parsing
              work on machines without AF_INET6.
      
              To select all IPv4 addresses from a table:
      
                      select * from foo where family(addr) = 4 ...
      
              Order by and other bits should all work.
      
      Michael Graff
      945543d9
    • Bruce Momjian's avatar
      Update: · 4dab978c
      Bruce Momjian authored
      < * Have SELECT '13 minutes'::interval display zero seconds
      > * Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle
      4dab978c
    • Bruce Momjian's avatar
      975674a9
    • Bruce Momjian's avatar
      Add: · b235fe3c
      Bruce Momjian authored
      > * Have SELECT '13 minutes'::interval display zero seconds
      b235fe3c
    • Bruce Momjian's avatar
      Add: · 2e963229
      Bruce Momjian authored
      > * Allow the regression tests to start postmaster with -i so the tests
      >   can be run on systems that don't support unix-domain sockets
      2e963229
    • Bruce Momjian's avatar
      Add: · c4ac8705
      Bruce Momjian authored
      > * Rename /scripts directory because they are all C programs now
      c4ac8705
    • Bruce Momjian's avatar
      Add: · 3b2e94de
      Bruce Momjian authored
      <
      > 	o Allow ALTER TABLE to modify column lengths and change to binary
      > 	  compatible types
      3b2e94de
    • Bruce Momjian's avatar
      Add: · 9b2cee0b
      Bruce Momjian authored
      > * Modify pg_get_triggerdef() to take a boolean to pretty-print,
      >  and use that as part of pg_dump along with psql
      >
      9b2cee0b
    • Bruce Momjian's avatar
      Update: · f703dee3
      Bruce Momjian authored
      * Allow UPDATE, DELETE to handle table aliases for self-joins [delete]
      f703dee3
    • Bruce Momjian's avatar
      typedef sa_family_t for cygwin. · 5249172e
      Bruce Momjian authored
      5249172e
    • Bruce Momjian's avatar
      Add: · 94468c6f
      Bruce Momjian authored
      > 	o Allow columns to be reordered using ALTER ... POSITION i col1 [,col2];
      > 	  have SELECT * and INSERT honor such ordering
      94468c6f
    • Bruce Momjian's avatar
      Do not include: · 646e7f84
      Bruce Momjian authored
      	#include <pwd.h>
      	#include <netdb.h>
      
      in MS CC/Borland builds.
      646e7f84
  2. 23 Jun, 2003 10 commits
  3. 22 Jun, 2003 10 commits
  4. 21 Jun, 2003 3 commits
  5. 20 Jun, 2003 4 commits