File: array_agg_pre84.sql

package info (click to toggle)
mimeo 1.5.1-20
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 5,300 kB
  • sloc: sql: 85,916; python: 81; makefile: 23; sh: 16
file content (10 lines) | stat: -rw-r--r-- 254 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
 
/*
 * array_agg() function for source database versions less than 8.4 but greater than 8.1. Ensure this is installed in the public schema
 */

CREATE AGGREGATE array_agg(anyelement) (
    SFUNC=array_append,
    STYPE=anyarray,
    INITCOND=’{}’
);