diff options
| author | Peter Eisentraut | 2006-02-27 16:09:50 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2006-02-27 16:09:50 +0000 |
| commit | 7f4f42fa100872507ca10d8e0f7d923acc266ee8 (patch) | |
| tree | c297cd70679cb60b470f8199ab707d80de108d5c /contrib/tablefunc/expected | |
| parent | fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c (diff) | |
Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in
particular get rid of single quotes around language names and old WITH ()
construct.
Diffstat (limited to 'contrib/tablefunc/expected')
| -rw-r--r-- | contrib/tablefunc/expected/tablefunc.out | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/contrib/tablefunc/expected/tablefunc.out b/contrib/tablefunc/expected/tablefunc.out index 50faf4390f1..84734ea41bb 100644 --- a/contrib/tablefunc/expected/tablefunc.out +++ b/contrib/tablefunc/expected/tablefunc.out @@ -128,7 +128,7 @@ CREATE FUNCTION crosstab_out(text, OUT rowid text, OUT att1 text, OUT att2 text, OUT att3 text) RETURNS setof record AS '$libdir/tablefunc','crosstab' -LANGUAGE 'C' STABLE STRICT; +LANGUAGE C STABLE STRICT; SELECT * FROM crosstab_out('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' ORDER BY 1,2;'); rowid | att1 | att2 | att3 -------+------+------+------ @@ -231,7 +231,7 @@ create type my_crosstab_result as ( CREATE FUNCTION crosstab_named(text, text) RETURNS setof my_crosstab_result AS '$libdir/tablefunc','crosstab_hash' -LANGUAGE 'C' STABLE STRICT; +LANGUAGE C STABLE STRICT; SELECT * FROM crosstab_named( 'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1', 'SELECT DISTINCT attribute FROM cth ORDER BY 1'); @@ -248,7 +248,7 @@ CREATE FUNCTION crosstab_out(text, text, OUT test_startdate timestamp, OUT volts float8) RETURNS setof record AS '$libdir/tablefunc','crosstab_hash' -LANGUAGE 'C' STABLE STRICT; +LANGUAGE C STABLE STRICT; SELECT * FROM crosstab_out( 'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1', 'SELECT DISTINCT attribute FROM cth ORDER BY 1'); |