NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit7f4f42f

committed

Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in

particular get rid of single quotes around language names and old WITH ()construct.

1 parentfe83b3e commit7f4f42fCopy full SHA for 7f4f42f

File tree

65 files changed

+967

-976

lines changed

contrib
- btree_gist
  - btree_gist.sql.in
- cube
  - cube.sql.in
- dblink
  - dblink.sql.in
- dbmirror
  - MirrorSetup.sql
- earthdistance
  - earthdistance.sql.in
- fulltextindex
  - README.fti
  - fti.c
  - fti.pl
  - fti.sql.in
- fuzzystrmatch
  - README.soundex
- intarray
  - _int.sql.in
  - expected
    - _int.out
- isbn_issn
  - isbn_issn.sql.in
- ltree
  - README.ltree
  - ltree.sql.in
- mac
  - createoui
- pg_buffercache
  - pg_buffercache.sql.in
- pg_freespacemap
  - pg_freespacemap.sql.in
- pg_trgm
  - pg_trgm.sql.in
- pgcrypto
  - pgcrypto.sql.in
- pgstattuple
  - README.pgstattuple
  - README.pgstattuple.euc_jp
  - pgstattuple.sql.in
- seg
  - seg.sql.in
- spi
  - autoinc.sql.in
  - insert_username.sql.in
  - moddatetime.sql.in
  - refint.sql.in
  - timetravel.sql.in
- tablefunc
  - README.tablefunc
  - expected
    - tablefunc.out
  - sql
    - tablefunc.sql
  - tablefunc.sql.in
- tsearch2
  - gendict
    - sql.IN
  - tsearch.sql.in
- xml2
  - pgxml.sql.in
src
- backend
  - commands
    - functioncmds.c
  - utils
    - fmgr
      - README
    - mb/conversion_procs
      - Makefile
- interfaces/ecpg/test
  - test_func.pgc
- pl
  - plpgsql/src
    - scan.l
  - tcl
    - expected
      - pltcl_setup.out
    - sql
      - pltcl_setup.sql
- test/regress
- tutorial
  - funcs.source

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

65 files changed

+967

-976

lines changed

`‎contrib/btree_gist/btree_gist.sql.in`

Lines changed: 121 additions & 121 deletions

Large diffs are not rendered by default.

`‎contrib/cube/cube.sql.in`

Lines changed: 33 additions & 33 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,12 +7,12 @@ SET search_path = public;`
`7`	`7`	`CREATE OR REPLACE FUNCTION cube_in(cstring)`
`8`	`8`	`RETURNS cube`
`9`	`9`	`AS 'MODULE_PATHNAME'`
`10`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`10`	`+LANGUAGEC IMMUTABLE STRICT;`
`11`	`11`
`12`	`12`	`CREATE OR REPLACE FUNCTION cube_out(cube)`
`13`	`13`	`RETURNS cstring`
`14`	`14`	`AS 'MODULE_PATHNAME'`
`15`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`15`	`+LANGUAGEC IMMUTABLE STRICT;`
`16`	`16`
`17`	`17`	`CREATE TYPE cube (`
`18`	`18`	`INTERNALLENGTH = variable,`
`@@ -27,7 +27,7 @@ COMMENT ON TYPE cube IS 'multi-dimensional cube ''(FLOAT-1, FLOAT-2, ..., FLOAT-`
`27`	`27`
`28`	`28`	`CREATE OR REPLACE FUNCTION cube(text) RETURNS cube`
`29`	`29`	`AS 'MODULE_PATHNAME'`
`30`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`30`	`+LANGUAGEC IMMUTABLE STRICT;`
`31`	`31`
`32`	`32`	`COMMENT ON FUNCTION cube(text) IS 'convert text to cube';`
`33`	`33`
`@@ -42,70 +42,70 @@ CREATE CAST (text AS cube) WITH FUNCTION cube(text) AS ASSIGNMENT;`
`42`	`42`	`CREATE OR REPLACE FUNCTION cube_eq(cube, cube)`
`43`	`43`	`RETURNS bool`
`44`	`44`	`AS 'MODULE_PATHNAME'`
`45`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`45`	`+LANGUAGEC IMMUTABLE STRICT;`
`46`	`46`
`47`	`47`	`COMMENT ON FUNCTION cube_eq(cube, cube) IS 'same as';`
`48`	`48`
`49`	`49`	`CREATE OR REPLACE FUNCTION cube_ne(cube, cube)`
`50`	`50`	`RETURNS bool`
`51`	`51`	`AS 'MODULE_PATHNAME'`
`52`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`52`	`+LANGUAGEC IMMUTABLE STRICT;`
`53`	`53`
`54`	`54`	`COMMENT ON FUNCTION cube_ne(cube, cube) IS 'different';`
`55`	`55`
`56`	`56`	`CREATE OR REPLACE FUNCTION cube_lt(cube, cube)`
`57`	`57`	`RETURNS bool`
`58`	`58`	`AS 'MODULE_PATHNAME'`
`59`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`59`	`+LANGUAGEC IMMUTABLE STRICT;`
`60`	`60`
`61`	`61`	`COMMENT ON FUNCTION cube_lt(cube, cube) IS 'lower than';`
`62`	`62`
`63`	`63`	`CREATE OR REPLACE FUNCTION cube_gt(cube, cube)`
`64`	`64`	`RETURNS bool`
`65`	`65`	`AS 'MODULE_PATHNAME'`
`66`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`66`	`+LANGUAGEC IMMUTABLE STRICT;`
`67`	`67`
`68`	`68`	`COMMENT ON FUNCTION cube_gt(cube, cube) IS 'greater than';`
`69`	`69`
`70`	`70`	`CREATE OR REPLACE FUNCTION cube_le(cube, cube)`
`71`	`71`	`RETURNS bool`
`72`	`72`	`AS 'MODULE_PATHNAME'`
`73`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`73`	`+LANGUAGEC IMMUTABLE STRICT;`
`74`	`74`
`75`	`75`	`COMMENT ON FUNCTION cube_le(cube, cube) IS 'lower than or equal to';`
`76`	`76`
`77`	`77`	`CREATE OR REPLACE FUNCTION cube_ge(cube, cube)`
`78`	`78`	`RETURNS bool`
`79`	`79`	`AS 'MODULE_PATHNAME'`
`80`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`80`	`+LANGUAGEC IMMUTABLE STRICT;`
`81`	`81`
`82`	`82`	`COMMENT ON FUNCTION cube_ge(cube, cube) IS 'greater than or equal to';`
`83`	`83`
`84`	`84`	`CREATE OR REPLACE FUNCTION cube_cmp(cube, cube)`
`85`	`85`	`RETURNS int4`
`86`	`86`	`AS 'MODULE_PATHNAME'`
`87`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`87`	`+LANGUAGEC IMMUTABLE STRICT;`
`88`	`88`
`89`	`89`	`COMMENT ON FUNCTION cube_cmp(cube, cube) IS 'btree comparison function';`
`90`	`90`
`91`	`91`	`CREATE OR REPLACE FUNCTION cube_contains(cube, cube)`
`92`	`92`	`RETURNS bool`
`93`	`93`	`AS 'MODULE_PATHNAME'`
`94`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`94`	`+LANGUAGEC IMMUTABLE STRICT;`
`95`	`95`
`96`	`96`	`COMMENT ON FUNCTION cube_contains(cube, cube) IS 'contains';`
`97`	`97`
`98`	`98`	`CREATE OR REPLACE FUNCTION cube_contained(cube, cube)`
`99`	`99`	`RETURNS bool`
`100`	`100`	`AS 'MODULE_PATHNAME'`
`101`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`101`	`+LANGUAGEC IMMUTABLE STRICT;`
`102`	`102`
`103`	`103`	`COMMENT ON FUNCTION cube_contained(cube, cube) IS 'contained in';`
`104`	`104`
`105`	`105`	`CREATE OR REPLACE FUNCTION cube_overlap(cube, cube)`
`106`	`106`	`RETURNS bool`
`107`	`107`	`AS 'MODULE_PATHNAME'`
`108`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`108`	`+LANGUAGEC IMMUTABLE STRICT;`
`109`	`109`
`110`	`110`	`COMMENT ON FUNCTION cube_overlap(cube, cube) IS 'overlaps';`
`111`	`111`
`@@ -114,17 +114,17 @@ COMMENT ON FUNCTION cube_overlap(cube, cube) IS 'overlaps';`
`114`	`114`	`CREATE OR REPLACE FUNCTION cube_union(cube, cube)`
`115`	`115`	`RETURNS cube`
`116`	`116`	`AS 'MODULE_PATHNAME'`
`117`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`117`	`+LANGUAGEC IMMUTABLE STRICT;`
`118`	`118`
`119`	`119`	`CREATE OR REPLACE FUNCTION cube_inter(cube, cube)`
`120`	`120`	`RETURNS cube`
`121`	`121`	`AS 'MODULE_PATHNAME'`
`122`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`122`	`+LANGUAGEC IMMUTABLE STRICT;`
`123`	`123`
`124`	`124`	`CREATE OR REPLACE FUNCTION cube_size(cube)`
`125`	`125`	`RETURNS float8`
`126`	`126`	`AS 'MODULE_PATHNAME'`
`127`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`127`	`+LANGUAGEC IMMUTABLE STRICT;`
`128`	`128`
`129`	`129`
`130`	`130`	`-- Misc N-dimensional functions`
`@@ -134,54 +134,54 @@ LANGUAGE 'C' IMMUTABLE STRICT;`
`134`	`134`	`CREATE OR REPLACE FUNCTION cube_distance(cube, cube)`
`135`	`135`	`RETURNS float8`
`136`	`136`	`AS 'MODULE_PATHNAME'`
`137`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`137`	`+LANGUAGEC IMMUTABLE STRICT;`
`138`	`138`
`139`	`139`	`-- Extracting elements functions`
`140`	`140`
`141`	`141`	`CREATE OR REPLACE FUNCTION cube_dim(cube)`
`142`	`142`	`RETURNS int4`
`143`	`143`	`AS 'MODULE_PATHNAME'`
`144`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`144`	`+LANGUAGEC IMMUTABLE STRICT;`
`145`	`145`
`146`	`146`	`CREATE OR REPLACE FUNCTION cube_ll_coord(cube, int4)`
`147`	`147`	`RETURNS float8`
`148`	`148`	`AS 'MODULE_PATHNAME'`
`149`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`149`	`+LANGUAGEC IMMUTABLE STRICT;`
`150`	`150`
`151`	`151`	`CREATE OR REPLACE FUNCTION cube_ur_coord(cube, int4)`
`152`	`152`	`RETURNS float8`
`153`	`153`	`AS 'MODULE_PATHNAME'`
`154`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`154`	`+LANGUAGEC IMMUTABLE STRICT;`
`155`	`155`
`156`	`156`	`CREATE OR REPLACE FUNCTION cube(float8) RETURNS cube`
`157`	`157`	`AS 'MODULE_PATHNAME', 'cube_f8'`
`158`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`158`	`+LANGUAGEC IMMUTABLE STRICT;`
`159`	`159`
`160`	`160`	`CREATE OR REPLACE FUNCTION cube(float8, float8) RETURNS cube`
`161`	`161`	`AS 'MODULE_PATHNAME', 'cube_f8_f8'`
`162`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`162`	`+LANGUAGEC IMMUTABLE STRICT;`
`163`	`163`
`164`	`164`	`CREATE OR REPLACE FUNCTION cube(cube, float8) RETURNS cube`
`165`	`165`	`AS 'MODULE_PATHNAME', 'cube_c_f8'`
`166`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`166`	`+LANGUAGEC IMMUTABLE STRICT;`
`167`	`167`
`168`	`168`	`CREATE OR REPLACE FUNCTION cube(cube, float8, float8) RETURNS cube`
`169`	`169`	`AS 'MODULE_PATHNAME', 'cube_c_f8_f8'`
`170`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`170`	`+LANGUAGEC IMMUTABLE STRICT;`
`171`	`171`
`172`	`172`	`-- Test if cube is also a point`
`173`	`173`
`174`	`174`	`CREATE OR REPLACE FUNCTION cube_is_point(cube)`
`175`	`175`	`RETURNS bool`
`176`	`176`	`AS 'MODULE_PATHNAME'`
`177`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`177`	`+LANGUAGEC IMMUTABLE STRICT;`
`178`	`178`
`179`	`179`	`-- Increasing the size of a cube by a radius in at least n dimensions`
`180`	`180`
`181`	`181`	`CREATE OR REPLACE FUNCTION cube_enlarge(cube, float8, int4)`
`182`	`182`	`RETURNS cube`
`183`	`183`	`AS 'MODULE_PATHNAME'`
`184`		`-LANGUAGE'C' IMMUTABLE STRICT;`
	`184`	`+LANGUAGEC IMMUTABLE STRICT;`
`185`	`185`
`186`	`186`	`--`
`187`	`187`	`-- OPERATORS`
`@@ -247,37 +247,37 @@ CREATE OPERATOR ~ (`
`247`	`247`	`CREATE OR REPLACE FUNCTION g_cube_consistent(internal,cube,int4)`
`248`	`248`	`RETURNS bool`
`249`	`249`	`AS 'MODULE_PATHNAME'`
`250`		`-LANGUAGE'C';`
	`250`	`+LANGUAGEC;`
`251`	`251`
`252`	`252`	`CREATE OR REPLACE FUNCTION g_cube_compress(internal)`
`253`	`253`	`RETURNS internal`
`254`	`254`	`AS 'MODULE_PATHNAME'`
`255`		`-LANGUAGE'C';`
	`255`	`+LANGUAGEC;`
`256`	`256`
`257`	`257`	`CREATE OR REPLACE FUNCTION g_cube_decompress(internal)`
`258`	`258`	`RETURNS internal`
`259`	`259`	`AS 'MODULE_PATHNAME'`
`260`		`-LANGUAGE'C';`
	`260`	`+LANGUAGEC;`
`261`	`261`
`262`	`262`	`CREATE OR REPLACE FUNCTION g_cube_penalty(internal,internal,internal)`
`263`	`263`	`RETURNS internal`
`264`	`264`	`AS 'MODULE_PATHNAME'`
`265`		`-LANGUAGE'C' STRICT;`
	`265`	`+LANGUAGEC STRICT;`
`266`	`266`
`267`	`267`	`CREATE OR REPLACE FUNCTION g_cube_picksplit(internal, internal)`
`268`	`268`	`RETURNS internal`
`269`	`269`	`AS 'MODULE_PATHNAME'`
`270`		`-LANGUAGE'C';`
	`270`	`+LANGUAGEC;`
`271`	`271`
`272`	`272`	`CREATE OR REPLACE FUNCTION g_cube_union(internal, internal)`
`273`	`273`	`RETURNS cube`
`274`	`274`	`AS 'MODULE_PATHNAME'`
`275`		`-LANGUAGE'C';`
	`275`	`+LANGUAGEC;`
`276`	`276`
`277`	`277`	`CREATE OR REPLACE FUNCTION g_cube_same(cube, cube, internal)`
`278`	`278`	`RETURNS internal`
`279`	`279`	`AS 'MODULE_PATHNAME'`
`280`		`-LANGUAGE'C';`
	`280`	`+LANGUAGEC;`
`281`	`281`
`282`	`282`
`283`	`283`	`-- Create the operator classes for indexing`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit7f4f42f

File tree

65 files changed

Some content is hidden

65 files changed

`‎contrib/btree_gist/btree_gist.sql.in`

`‎contrib/cube/cube.sql.in`

0 commit comments