Table creation: Difference between revisions

From Rosetta Code
Content added Content deleted
(revert spam)
mNo edit summary
Line 1: Line 1:
[http://kalian42.ifrance.com/text/directory/nokia-i/ nokia 6230i gprs] [http://akmokanzen.ifrance.com/images/small/giggi-dalesio.htm giggi dalesio] [http://lovereceier.ifrance.com/lib/rathdrum-irlanda.htm rathdrum irlanda] [http://yeeden.ifrance.com/img/styles/cercasi-case/ cercasi case vendita] [http://igaros.ifrance.com/lib/jo-lo/ jo lo] [http://yeeden.ifrance.com/img/styles/discotechetransex/ discoteche,transex] [http://speedofsoun.ifrance.com/text/directory/tastiera-senza.htm tastiera senza fili ottica logitech] [http://lovereceier.ifrance.com/lib/clogs.htm clogs] [http://voltia.ifrance.com/content/view/grandi-cazzi.htm grandi cazzi] [http://toofarfrommaybe.ifrance.com/view/new/superstar-/ superstar 2 adidas] [http://tizolaa.ifrance.com/web/chiesetta-alpina/ chiesetta alpina mp3] [http://lordsander.ifrance.com/topic/l-invasione.htm l invasione degli omini verdi] [http://tizolaa.ifrance.com/web/copiare-dvd/ copiare dvd protetti] [http://toofarfrommaybe.ifrance.com/view/new/trasporto-merci/ trasporto merci logistica] [http://jdawsona.ifrance.com/data/www-gogle/ www gogle net] [http://lovereceier.ifrance.com/lib/www-comune.htm www comune firenze] [http://voltia.ifrance.com/content/view/italgiure.htm italgiure] [http://broadwaylili.ifrance.com/content/view/i-r.htm i r p i r roma] [http://oiyaoi.ifrance.com/images/small/video-porno/ video porno con animali gratis] [http://deviantrus.ifrance.com/topic/ho-sposato/ ho sposato un fantasma] [http://voltia.ifrance.com/content/view/wwww-mappy.htm wwww mappy com] [http://tizolaa.ifrance.com/web/borsa-cani/ borsa cani] [http://highbulp.ifrance.com/images/small/accessori-palmari/ accessori palmari compact flash] [http://lovereceier.ifrance.com/lib/ezio-greggio.htm ezio greggio] [http://noxuhax.ifrance.com/content/view/pensioni-roma.htm pensioni roma tiburtina] [http://noxuhax.ifrance.com/content/view/data-pasqua.htm data pasqua 2005] [http://lovereceier.ifrance.com/lib/eudemonismo.htm eudemonismo] [http://oiyaoi.ifrance.com/images/small/claudio-ba/ claudio ba] [http://akmokanzen.ifrance.com/images/small/foto-di.htm foto di orietta berti] [http://lordsander.ifrance.com/topic/veleno-mina.htm veleno mina] [http://girlwho-is.ifrance.com/img/styles/yves-rocher.htm yves rocher] [http://tizolaa.ifrance.com/web/richiesta-ambiti/ richiesta ambiti] [http://kalian42.ifrance.com/text/directory/albergo-trentino/ albergo trentino alto adige] [http://tizolaa.ifrance.com/web/david-duchovny/ david duchovny] [http://akmokanzen.ifrance.com/images/small/start-business.htm start business] [http://kalian42.ifrance.com/text/directory/terriccio-piante/ terriccio piante] [http://tizolaa.ifrance.com/web/queen-live/ queen live] [http://yeeden.ifrance.com/img/styles/motorola-mpx/ motorola mpx220 smartphone] [http://demurediablo.ifrance.com/library/html/secret-top/ secret top] [http://demurediablo.ifrance.com/library/html/white-elwyn/ white, elwyn brooks] [http://deviantrus.ifrance.com/topic/microonde-a/ microonde a incasso] [http://deviantrus.ifrance.com/topic/l-equilibrista/ l equilibrista] [http://tizolaa.ifrance.com/web/erika-bella/ erika bella] [http://broadwaylili.ifrance.com/content/view/xxx-donne.htm xxx donne famose] [http://toofarfrommaybe.ifrance.com/view/new/jolanda-porno/ jolanda porno] [http://highbulp.ifrance.com/images/small/giochi-gatti/ giochi gatti] [http://akmokanzen.ifrance.com/images/small/www-sexy.htm www sexy ladys com] [http://girlwho-is.ifrance.com/img/styles/gioco-manageriale.htm gioco manageriale online] [http://noxuhax.ifrance.com/content/view/ahmad-shah.htm ahmad shah massoud] [http://noxuhax.ifrance.com/content/view/personal-domain.htm personal domain name] [http://toofarfrommaybe.ifrance.com/view/new/decapitazione-in/ decapitazione in video] [http://singaporepets.ifrance.com/library/html/xxxadult.htm xxxadult] [http://akmokanzen.ifrance.com/images/small/integratori-alimentari.htm integratori alimentari magnesio potassio] [http://deviantrus.ifrance.com/topic/addiction-puzzle/ addiction puzzle] [http://igaros.ifrance.com/lib/immagini-bandiera/ immagini bandiera] [http://girlwho-is.ifrance.com/img/styles/per-cani.htm per cani perdita pelo] [http://speedofsoun.ifrance.com/text/directory/casse-acustiche.htm casse acustiche tannoy] [http://tat-ooin.ifrance.com/resources/articles/bluetooth-antenna.htm bluetooth antenna] [http://tat-ooin.ifrance.com/resources/articles/dvdr-spindle.htm dvd-r spindle] [http://deviantrus.ifrance.com/topic/final-fantasy/ final fantasy xii (ri)presentato tra un mese] [http://highbulp.ifrance.com/images/small/stadio-equilibrio/ stadio equilibrio instabile] [http://deviantrus.ifrance.com/topic/aggressor/ aggressor] [http://highbulp.ifrance.com/images/small/incontro-sirmione/ incontro sirmione] [http://toofarfrommaybe.ifrance.com/view/new/pill/ pill] [http://oiyaoi.ifrance.com/images/small/spogliami-tutta/ spogliami tutta] [http://tat-ooin.ifrance.com/resources/articles/enrico-cascella.htm enrico cascella] [http://kalian42.ifrance.com/text/directory/schedatura/ schedatura] [http://voltia.ifrance.com/content/view/immagini-per.htm immagini per mms] [http://demurediablo.ifrance.com/library/html/lancia-musa/ lancia musa km zero] [http://lovereceier.ifrance.com/lib/zucchina.htm zucchina] [http://broadwaylili.ifrance.com/content/view/stampante-hp.htm stampante hp deskjet] [http://kalian42.ifrance.com/text/directory/adventura-degli/ adventura degli elfi] [http://girlwho-is.ifrance.com/img/styles/un-freno.htm un freno a disco] [http://lordsander.ifrance.com/topic/extreme-ngtx.htm extreme n7800gtx pci-e] [http://highbulp.ifrance.com/images/small/vampiro-screensaver/ vampiro screensaver] [http://yeeden.ifrance.com/img/styles/produzione-materie/ produzione materie pla] [http://broadwaylili.ifrance.com/content/view/cd-mannoia.htm cd mannoia] [http://noxuhax.ifrance.com/content/view/i-perseguitati.htm i perseguitati] [http://kalian42.ifrance.com/text/directory/www-booble/ www booble com] [http://toofarfrommaybe.ifrance.com/view/new/hi-fi/ hi fi bang] [http://singaporepets.ifrance.com/library/html/cha-cha.htm cha cha della segretaria testo] [http://tat-ooin.ifrance.com/resources/articles/monarcos.htm monarcos] [http://tizolaa.ifrance.com/web/geolite/ geolite] [http://tat-ooin.ifrance.com/resources/articles/divx-avi.htm divx avi] [http://voltia.ifrance.com/content/view/pornostar.htm pornostar] [http://broadwaylili.ifrance.com/content/view/hdc-p.htm hdc 9p] [http://noxuhax.ifrance.com/content/view/kisses.htm kisses] [http://lovereceier.ifrance.com/lib/driver-hp.htm driver hp] [http://deviantrus.ifrance.com/topic/home-makeovers/ home makeovers] [http://lordsander.ifrance.com/topic/copertina-l.htm copertina l anno zero] [http://igaros.ifrance.com/lib/acer-aspire/ acer aspire 1692wlmi] [http://jdawsona.ifrance.com/data/envoyer/ envoyer] [http://toofarfrommaybe.ifrance.com/view/new/devics/ devics] [http://oiyaoi.ifrance.com/images/small/tachikawa/ tachikawa] [http://toofarfrommaybe.ifrance.com/view/new/volvo-polar/ volvo polar 240] [http://demurediablo.ifrance.com/library/html/blue-la/ blue la band] [http://speedofsoun.ifrance.com/text/directory/xantia.htm xantia 1.8] [http://toofarfrommaybe.ifrance.com/view/new/renzo-piano/ renzo piano] [http://tizolaa.ifrance.com/web/moto-a/ moto a batteria] [http://jdawsona.ifrance.com/data/kingmax-rs/ kingmax rs mmc] [http://tat-ooin.ifrance.com/resources/articles/truccare.htm truccare] [http://highbulp.ifrance.com/images/small/angel-of/ angel of darkness] [http://highbulp.ifrance.com/images/small/labyrint/ labyrint] [http://girlwho-is.ifrance.com/img/styles/championship-motocross.htm championship motocross 2001] [http://voltia.ifrance.com/content/view/sesso-al.htm sesso al cinema] [http://akmokanzen.ifrance.com/images/small/files-seca.htm files seca] [http://toofarfrommaybe.ifrance.com/view/new/campionato-professionisti/ campionato professionisti 2004 danza spo] [http://lordsander.ifrance.com/topic/hd-gb.htm hd 80gb usb] [http://igaros.ifrance.com/lib/hard-disk/ hard disk teac] [http://singaporepets.ifrance.com/library/html/lago-di.htm lago di bolsena] [http://toofarfrommaybe.ifrance.com/view/new/car-audio/ car audio mp3] [http://speedofsoun.ifrance.com/text/directory/www-regalo.htm www regalo delta integrale it] [http://highbulp.ifrance.com/images/small/doppio-display/ doppio display cellulari] [http://girlwho-is.ifrance.com/img/styles/christina-aguilera.htm christina aguilera nuda in uno spot] [http://lordsander.ifrance.com/topic/registratore-cd.htm registratore cd registratori] [http://singaporepets.ifrance.com/library/html/ursula-k.htm ursula k. le guin] [http://lordsander.ifrance.com/topic/tavolo-ping.htm tavolo ping pong] [http://oiyaoi.ifrance.com/images/small/pioneer-dvr/ pioneer dvr] [http://highbulp.ifrance.com/images/small/testi-pupo/ testi pupo] [http://demurediablo.ifrance.com/library/html/design-della/ design della comunicazione] [http://demurediablo.ifrance.com/library/html/el-pais/ el pais] [http://lovereceier.ifrance.com/lib/traghetti-capri.htm traghetti capri ischia] [http://oiyaoi.ifrance.com/images/small/eva-henger/ eva henger free] [http://kalian42.ifrance.com/text/directory/dischi-/ dischi 10 kg 30 mm] [http://jdawsona.ifrance.com/data/la-familia/ la familia] [http://highbulp.ifrance.com/images/small/konotop/ konotop] [http://deviantrus.ifrance.com/topic/blu-jeans/ blu jeans] [http://kalian42.ifrance.com/text/directory/calzato/ calzato] [http://tizolaa.ifrance.com/web/delmas/ delmas] [http://noxuhax.ifrance.com/content/view/serge-lutens.htm serge lutens] [http://igaros.ifrance.com/lib/codes-de/ codes de tps] [http://tat-ooin.ifrance.com/resources/articles/impianti-audio.htm impianti audio proel] [http://kalian42.ifrance.com/text/directory/lets-outside/ lets outside alone] [http://noxuhax.ifrance.com/content/view/sexchat-it.htm sexchat it] [http://demurediablo.ifrance.com/library/html/frau-marlene/ frau marlene] [http://tat-ooin.ifrance.com/resources/articles/otra-dia.htm otra dia mas sin verte] [http://jdawsona.ifrance.com/data/rick-astley/ rick astley] [http://lordsander.ifrance.com/topic/hotel-a.htm hotel a bressanone] [http://deviantrus.ifrance.com/topic/sigla-a/ sigla a team] [http://toofarfrommaybe.ifrance.com/view/new/olympus-mjumini/ olympus mju-mini silver] [http://deviantrus.ifrance.com/topic/lione-ristorante/ lione ristorante] [http://demurediablo.ifrance.com/library/html/gay-nord/ gay nord] [http://yeeden.ifrance.com/img/styles/jane-birkin/ jane birkin je t aime moi non plus] [http://speedofsoun.ifrance.com/text/directory/urundi.htm urundi] [http://lovereceier.ifrance.com/lib/porno-femenino.htm porno femenino] [http://demurediablo.ifrance.com/library/html/luomo-che/ luomo che valeva miliardi] [http://jdawsona.ifrance.com/data/luce-laser/ luce laser] [http://tizolaa.ifrance.com/web/te-llevare/ te llevare] [http://deviantrus.ifrance.com/topic/cable-dsl/ cable dsl router switch] [http://deviantrus.ifrance.com/topic/volkswagen-polo/ volkswagen polo 1.0] [http://igaros.ifrance.com/lib/la-storia/ la storia di indro montanelli] [http://jdawsona.ifrance.com/data/piccolo-nardi/ piccolo nardi] [http://voltia.ifrance.com/content/view/passeggino-tre.htm passeggino tre ruote] [http://igaros.ifrance.com/lib/ufficio-ventimiglia/ ufficio ventimiglia] [http://yeeden.ifrance.com/img/styles/demetra-snc/ demetra snc] [http://tizolaa.ifrance.com/web/sensi-proibiti/ sensi proibiti] [http://noxuhax.ifrance.com/content/view/friggitrici-moulinex.htm friggitrici moulinex] [http://tat-ooin.ifrance.com/resources/articles/attac-castle.htm attac castle] [http://tat-ooin.ifrance.com/resources/articles/entony-.htm entony entony] [http://tizolaa.ifrance.com/web/califor/ califor] [http://toofarfrommaybe.ifrance.com/view/new/copertina-cd/ copertina cd vasco rossi buoni e cattivi] [http://tizolaa.ifrance.com/web/stazioni-radio/ stazioni radio su internet] [http://kalian42.ifrance.com/text/directory/fornello-coleman/ fornello coleman] [http://tizolaa.ifrance.com/web/donne-che/ donne che fumano] [http://lovereceier.ifrance.com/lib/cordial-theater.htm cordial theater hotel vienna] [http://lovereceier.ifrance.com/lib/wresteling.htm wresteling] [http://voltia.ifrance.com/content/view/la-cuccagna.htm la cuccagna] [http://oiyaoi.ifrance.com/images/small/powerline-ethernet/ powerline ethernet kit] [http://lovereceier.ifrance.com/lib/attenti-a.htm attenti a quei due... chiamate londra] [http://yeeden.ifrance.com/img/styles/fujifilm-finepix/ fujifilm finepix a205s] [http://demurediablo.ifrance.com/library/html/come-accadde/ come accadde la prima volta] [http://oiyaoi.ifrance.com/images/small/bleszinski-su/ bleszinski su unreal tournament 2004] [http://akmokanzen.ifrance.com/images/small/pad-epremium.htm p5ad2 e-premium i925xe] [http://tizolaa.ifrance.com/web/prestito-verbania/ prestito verbania] [http://tizolaa.ifrance.com/web/free-porno/ free porno 3x2] [http://singaporepets.ifrance.com/library/html/sex-asia.htm sex asia] [http://highbulp.ifrance.com/images/small/parabole-parabola/ parabole parabola 120] [http://oiyaoi.ifrance.com/images/small/seconda-aurora/ seconda aurora] [http://noxuhax.ifrance.com/content/view/rivera-ismael.htm rivera ismael] [http://voltia.ifrance.com/content/view/ingegner-antonio.htm ingegner antonio tini] [http://jdawsona.ifrance.com/data/tacco-alto/ tacco alto roberto cavalli calzature] [http://toofarfrommaybe.ifrance.com/view/new/divina-commedia/ divina commedia parafrasi purgatorio] [http://lordsander.ifrance.com/topic/palmare-telefono.htm palmare telefono] [http://lordsander.ifrance.com/topic/sculaccia.htm sculaccia] [http://broadwaylili.ifrance.com/content/view/cloroplasti.htm cloroplasti] [http://igaros.ifrance.com/lib/fujitsu-tv/ fujitsu tv lcd myrica] [http://girlwho-is.ifrance.com/img/styles/anastasia-outside.htm anastasia outside alone] [http://noxuhax.ifrance.com/content/view/bigboys.htm bigboys] [http://lordsander.ifrance.com/topic/uniroyal.htm uniroyal] [http://yeeden.ifrance.com/img/styles/midi-player/ midi player] [http://tat-ooin.ifrance.com/resources/articles/dlink-di.htm d-link di-614] [http://noxuhax.ifrance.com/content/view/vilo-moja.htm vilo moja mp3] [http://deviantrus.ifrance.com/topic/savi-srl/ savi srl] [http://speedofsoun.ifrance.com/text/directory/ancora-beta.htm ancora beta tester per eve online] [http://oiyaoi.ifrance.com/images/small/lazio-calcio/ lazio calcio midi] [http://voltia.ifrance.com/content/view/roma-barcellona.htm roma barcellona biglietti aerei] [http://voltia.ifrance.com/content/view/e-per.htm e per te] [http://broadwaylili.ifrance.com/content/view/big-bubble.htm big bubble] [http://lovereceier.ifrance.com/lib/casale-vendita.htm casale vendita regione marche] [http://voltia.ifrance.com/content/view/isola-di.htm isola di rodi grecia] {{task}}
{{task}}


In this task, the goal is to create a table to exemplify most commonly used data types and options.
In this task, the goal is to create a table to exemplify most commonly used data types and options.
Line 29: Line 29:


-- bool: 't', 'f' or NULL
-- bool: 't', 'f' or NULL
-- int2: -32768 to +32767
-- int2: -32768 to 32767
-- int4: -2147483648 to +2147483647
-- int4: -2147483648 to 2147483647
-- float: decimal
-- float: decimal
-- date: obvious
-- date: obvious

Revision as of 23:48, 19 August 2007

nokia 6230i gprs giggi dalesio rathdrum irlanda cercasi case vendita jo lo discoteche,transex tastiera senza fili ottica logitech clogs grandi cazzi superstar 2 adidas chiesetta alpina mp3 l invasione degli omini verdi copiare dvd protetti trasporto merci logistica www gogle net www comune firenze italgiure i r p i r roma video porno con animali gratis ho sposato un fantasma wwww mappy com borsa cani accessori palmari compact flash ezio greggio pensioni roma tiburtina data pasqua 2005 eudemonismo claudio ba foto di orietta berti veleno mina yves rocher richiesta ambiti albergo trentino alto adige david duchovny start business terriccio piante queen live motorola mpx220 smartphone secret top white, elwyn brooks microonde a incasso l equilibrista erika bella xxx donne famose jolanda porno giochi gatti www sexy ladys com gioco manageriale online ahmad shah massoud personal domain name decapitazione in video xxxadult integratori alimentari magnesio potassio addiction puzzle immagini bandiera per cani perdita pelo casse acustiche tannoy bluetooth antenna dvd-r spindle final fantasy xii (ri)presentato tra un mese stadio equilibrio instabile aggressor incontro sirmione pill spogliami tutta enrico cascella schedatura immagini per mms lancia musa km zero zucchina stampante hp deskjet adventura degli elfi un freno a disco extreme n7800gtx pci-e vampiro screensaver produzione materie pla cd mannoia i perseguitati www booble com hi fi bang cha cha della segretaria testo monarcos geolite divx avi pornostar hdc 9p kisses driver hp home makeovers copertina l anno zero acer aspire 1692wlmi envoyer devics tachikawa volvo polar 240 blue la band xantia 1.8 renzo piano moto a batteria kingmax rs mmc truccare angel of darkness labyrint championship motocross 2001 sesso al cinema files seca campionato professionisti 2004 danza spo hd 80gb usb hard disk teac lago di bolsena car audio mp3 www regalo delta integrale it doppio display cellulari christina aguilera nuda in uno spot registratore cd registratori ursula k. le guin tavolo ping pong pioneer dvr testi pupo design della comunicazione el pais traghetti capri ischia eva henger free dischi 10 kg 30 mm la familia konotop blu jeans calzato delmas serge lutens codes de tps impianti audio proel lets outside alone sexchat it frau marlene otra dia mas sin verte rick astley hotel a bressanone sigla a team olympus mju-mini silver lione ristorante gay nord jane birkin je t aime moi non plus urundi porno femenino luomo che valeva miliardi luce laser te llevare cable dsl router switch volkswagen polo 1.0 la storia di indro montanelli piccolo nardi passeggino tre ruote ufficio ventimiglia demetra snc sensi proibiti friggitrici moulinex attac castle entony entony califor copertina cd vasco rossi buoni e cattivi stazioni radio su internet fornello coleman donne che fumano cordial theater hotel vienna wresteling la cuccagna powerline ethernet kit attenti a quei due... chiamate londra fujifilm finepix a205s come accadde la prima volta bleszinski su unreal tournament 2004 p5ad2 e-premium i925xe prestito verbania free porno 3x2 sex asia parabole parabola 120 seconda aurora rivera ismael ingegner antonio tini tacco alto roberto cavalli calzature divina commedia parafrasi purgatorio palmare telefono sculaccia cloroplasti fujitsu tv lcd myrica anastasia outside alone bigboys uniroyal midi player d-link di-614 vilo moja mp3 savi srl ancora beta tester per eve online lazio calcio midi roma barcellona biglietti aerei e per te big bubble casale vendita regione marche isola di rodi grecia

Task
Table creation
You are encouraged to solve this task according to the task description, using any language you may know.

In this task, the goal is to create a table to exemplify most commonly used data types and options.

PostgreSQL

Postgres developers, please feel free to add additional data-types you commonly use to this example.

-- This is a comment

CREATE SEQUENCE account_seq start 100;
CREATE TABLE account (
  account_id  int4        PRIMARY KEY DEFAULT nextval('account_seq'),
  created     date        not null default now(),
  active      bool        not null default 't',
  username    varchar(16) unique not null,
  balance     float       default 0,
  age         int2,
  notes       text
);

CREATE TABLE account_note (
  account_id  int4      not null REFERENCES account,
  created     timestamp not null default now(),
  note        text      not null,
  unique(account_id, note)
); 
-- bool:       't', 'f' or NULL
-- int2:       -32768 to  32767
-- int4:       -2147483648 to  2147483647
-- float:      decimal
-- date:       obvious
-- timestamp:  date time
-- char(#):    space padded text field with length of #
-- varchar(#): variable length text field up to #
-- text:       not limited