aboutsummaryrefslogtreecommitdiff
path: root/contrib/spi/preprocessor/example.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-12-03 19:20:40 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-12-03 19:20:40 +0000
commit50eed107ae63dc503fc58bc1a2e679ce232e283c (patch)
treee9f7a1aadd4f9e95c5f02afa5e98901801c3e0e1 /contrib/spi/preprocessor/example.sql
parent739338e88a608955ddfdc6ea125a3b6e959176c9 (diff)
downloadpostgresql-50eed107ae63dc503fc58bc1a2e679ce232e283c.tar.gz
postgresql-50eed107ae63dc503fc58bc1a2e679ce232e283c.zip
Remove contrib/spi/preprocessor, which has been uninteresting ever
since we supported standard FOREIGN KEY constraint syntax. It was harmless enough just sitting there, but the prospect of having to document it is surely more work than it's worth.
Diffstat (limited to 'contrib/spi/preprocessor/example.sql')
-rw-r--r--contrib/spi/preprocessor/example.sql37
1 files changed, 0 insertions, 37 deletions
diff --git a/contrib/spi/preprocessor/example.sql b/contrib/spi/preprocessor/example.sql
deleted file mode 100644
index e53c84a1517..00000000000
--- a/contrib/spi/preprocessor/example.sql
+++ /dev/null
@@ -1,37 +0,0 @@
--- Note the syntax is strict because i have no time to write better perl filter.
---
--- [blank] is 1 blank
--- at the end of an interesting line must be a [,] or [--]
--- [ending] must be a , or --
---
--- foreign[blank]key[blank]([blank]keyname,..,keyname[blank])[blank]references[blank]table[blank][ending]
---
--- step1 < example.sql | step2.pl > foreign_key_triggers.sql
---
--- step1.c is a simple program that UPPERCASE ALL . I know that is simple implementing in Perl
--- bu i haven't time
-
-
-CREATE TABLE
-gruppo
-(
-codice_gruppo int4 NOT NULL,
-descrizione varchar(32) NOT NULL
-primary key ( codice_gruppo )
-
-) ;
-
---
--- fa_parte : Appartenenza di una Azienda Conatto o Cliente ad un certo GRUPPO
---
-
-CREATE TABLE
-fa_parte
-(
-codice_gruppo int4 NOT NULL,
-codice_contatto int4 NOT NULL,
-
-primary key ( codice_gruppo,codice_contatto ) ,
-foreign key ( codice_gruppo ) references gruppo --
-);
-