Changeset 665 for trunk


Ignore:
Timestamp:
Sep 21, 2008, 10:05:43 PM (11 years ago)
Author:
Nick Burch
Message:

Handy AGGREGATE function

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/schema_postgres.sql

    r647 r665  
    9494CREATE INDEX i_postcode_source ON postcodes (source);
    9595CREATE INDEX i_bad_postcodes_postcode ON bad_postcodes (postcode);
     96
     97-- So we can do fancy stuff
     98CREATE AGGREGATE to_array (
     99  sfunc = array_append,
     100  basetype = anyelement,
     101  stype = anyarray,
     102  initcond = '{}'
     103);
Note: See TracChangeset for help on using the changeset viewer.