Table creation: Difference between revisions

From Rosetta Code
Content added Content deleted
mNo edit summary
Line 1: Line 1:
{{task}}
[http://nettikyzarc.ifrance.com/content/view/federscacchi-it/ federscacchi it] [http://bang-sigh.ifrance.com/images/small/nikon-dx/ nikon dx 70s] [http://dgdeeper.ifrance.com/img/styles/beach-nude.htm beach nude] [http://bang-sigh.ifrance.com/images/small/zeljko-supermen/ zeljko supermen] [http://sarah531.ifrance.com/lib/digitaal.htm digitaal] [http://reikofanel.ifrance.com/web/dualcore-bit.htm dualcore 64bit] [http://blackblackblack.ifrance.com/lib/genero.htm genero] [http://dgdeeper.ifrance.com/img/styles/cartoline-prima.htm cartoline prima comunione] [http://kiravina.ifrance.com/html/pellizzari-achille.htm pellizzari achille] [http://twobit77.ifrance.com/description/lib/giacinto-facchetti/ giacinto facchetti] [http://blackblackblack.ifrance.com/lib/misure-locali.htm misure locali] [http://kiravina.ifrance.com/html/download-tesi.htm download tesi] [http://soundwave106.ifrance.com/resources/articles/casse-acustiche/ casse acustiche 2 1 philips] [http://crazybird027.ifrance.com/view/new/scheda-video/ scheda video nvidia 256mb] [http://reikofanel.ifrance.com/web/elvox.htm elvox] [http://itsmeladuh.ifrance.com/content/view/video-scandalo/ video scandalo celebrita] [http://alvonina.ifrance.com/img/styles/contacalorie/ contacalorie] [http://csmith06.ifrance.com/lib/batteria-compaq.htm batteria compaq presario] [http://blackblackblack.ifrance.com/lib/bluetooth.htm bluetooth 2 0] [http://kirizz.ifrance.com/html/film-gay.htm film gay gratis] [http://faithib.ifrance.com/description/lib/musica-de.htm musica de chicha] [http://reikofanel.ifrance.com/web/strike-mazzola.htm strike mazzola] [http://bang-sigh.ifrance.com/images/small/cucce-per/ cucce per cane] [http://nettikyzarc.ifrance.com/content/view/s-maria/ s maria a bagno] [http://faithib.ifrance.com/description/lib/de-javu.htm de javu i can t stop] [http://kirizz.ifrance.com/html/tyler.htm tyler] [http://twobit77.ifrance.com/description/lib/progetto-bagno/ progetto bagno] [http://csmith06.ifrance.com/lib/consumatori-it.htm consumatori it] [http://kirizz.ifrance.com/html/video-di.htm video di in the shadows in versione finl] [http://asing-argirl.ifrance.com/images/small/moto-bmw/ moto bmw usata] [http://kiravina.ifrance.com/html/gradient-.htm gradient 50 cps 5 mg] [http://twobit77.ifrance.com/description/lib/tengo-ganas/ tengo ganas victor] [http://csmith06.ifrance.com/lib/amd.htm amd 2 4] [http://crazybird027.ifrance.com/view/new/inno-agli/ inno agli alpini] [http://alvonina.ifrance.com/img/styles/mais-que/ mais que nada] [http://asing-argirl.ifrance.com/images/small/ingrosso-bomboniera/ ingrosso bomboniera] [http://kiravina.ifrance.com/html/video-born.htm video born to make you happy] [http://sarah531.ifrance.com/lib/status.htm status 30] [http://itsmeladuh.ifrance.com/content/view/jazz-umbria/ jazz umbria anniversario] [http://faithib.ifrance.com/description/lib/sampei-vol.htm sampei vol 04] [http://mania555.ifrance.com/img/styles/jayz-streets.htm jayz streets is watching the movie] [http://bladiblada.ifrance.com/resources/articles/ruslana-wild.htm ruslana wild dance ukraine mp3] [http://bladiblada.ifrance.com/resources/articles/museo-del.htm museo del louvre] [http://twobit77.ifrance.com/description/lib/lancia-y/ lancia y 2001] [http://kiravina.ifrance.com/html/gd-panasonic.htm gd87 panasonic cavo usb] [http://asing-argirl.ifrance.com/images/small/annuncio-lavoro/ annuncio lavoro offerta lavoro] [http://faithib.ifrance.com/description/lib/metal-gear.htm metal gear acid] [http://itsmeladuh.ifrance.com/content/view/disalberare/ disalberare] [http://kirizz.ifrance.com/html/meccanici.htm meccanici] [http://bang-sigh.ifrance.com/images/small/equazioni-liceo/ equazioni liceo classico] [http://twobit77.ifrance.com/description/lib/uno-strano/ uno strano percorso degli 883] [http://sarah531.ifrance.com/lib/lettore-portatile.htm lettore portatile divx mp3 gb] [http://dgdeeper.ifrance.com/img/styles/codici-di.htm codici di sblocco per tre] [http://bladiblada.ifrance.com/resources/articles/fax-online.htm fax online] [http://csmith06.ifrance.com/lib/masterizzatore-lg.htm masterizzatore lg black] [http://faithib.ifrance.com/description/lib/video-ostaggio.htm video ostaggio italiano ucciso] [http://itsmeladuh.ifrance.com/content/view/inverter-daikin/ inverter daikin] [http://nettikyzarc.ifrance.com/content/view/maglietta-maradona/ maglietta maradona] [http://itsmeladuh.ifrance.com/content/view/mariah/ mariah] [http://bladiblada.ifrance.com/resources/articles/ariston-avxl.htm ariston avxl 108] [http://nettikyzarc.ifrance.com/content/view/attrici-trans/ attrici trans] [http://kiravina.ifrance.com/html/servi-della.htm servi della gleba] [http://toupheefee.ifrance.com/text/directory/la-familia/ la familia] [http://csmith06.ifrance.com/lib/testi-stranieri.htm testi stranieri] [http://bang-sigh.ifrance.com/images/small/lavatrici-indesit/ lavatrici indesit wil 106] [http://alvonina.ifrance.com/img/styles/k-maro/ k maro mid] [http://itsmeladuh.ifrance.com/content/view/hollow-fibre/ hollow fibre] [http://bladiblada.ifrance.com/resources/articles/crystal.htm crystal] [http://alvonina.ifrance.com/img/styles/sebastiane/ sebastiane] [http://alvonina.ifrance.com/img/styles/music-for/ music for free] [http://blackblackblack.ifrance.com/lib/mahjohng.htm mahjohng] [http://blackblackblack.ifrance.com/lib/giochi-shangai.htm giochi shangai] [http://dgdeeper.ifrance.com/img/styles/i-peccatori.htm i peccatori della foresta nera] [http://twobit77.ifrance.com/description/lib/su-di/ su di noi free] [http://reikofanel.ifrance.com/web/ati-xpro.htm ati x850pro] [http://alvonina.ifrance.com/img/styles/fortuna-gps/ fortuna gps] [http://bladiblada.ifrance.com/resources/articles/stanley.htm stanley] [http://asing-argirl.ifrance.com/images/small/www-bakire/ www bakire com] [http://hethrfethr77.ifrance.com/content/view/furgoncino/ furgoncino] [http://blackblackblack.ifrance.com/lib/mitsubishi-runner.htm mitsubishi runner] [http://dgdeeper.ifrance.com/img/styles/opel-astra.htm opel astra sw elegance] [http://kirizz.ifrance.com/html/vendita-suonerie.htm vendita suonerie] [http://sarah531.ifrance.com/lib/sesso-uomo.htm sesso uomo] [http://blackblackblack.ifrance.com/lib/download-free.htm download free software etichetta cd] [http://nettikyzarc.ifrance.com/content/view/la-tua/ la tua pelle o la mia] [http://kiravina.ifrance.com/html/pixma-ip.htm pixma ip5000 canon] [http://soundwave106.ifrance.com/resources/articles/efemerides/ efemerides] [http://alvonina.ifrance.com/img/styles/fine-settimana/ fine settimana week end] [http://faithib.ifrance.com/description/lib/invito-festa.htm invito festa compleanno] [http://soundwave106.ifrance.com/resources/articles/sagre-in/ sagre in piemonte] [http://toupheefee.ifrance.com/text/directory/router-us/ router us robotics wireless] [http://csmith06.ifrance.com/lib/testo-i.htm testo i giardini di maggio di battisti] [http://bladiblada.ifrance.com/resources/articles/xara-web.htm xara web style] [http://crazybird027.ifrance.com/view/new/rs-mmc/ rs mmc dv dual voltage 512] [http://soundwave106.ifrance.com/resources/articles/professionisti/ professionisti] [http://dgdeeper.ifrance.com/img/styles/nadiya-et.htm nadiya et c est party] [http://blackblackblack.ifrance.com/lib/amstrad-lettore.htm amstrad lettore dvd dvx tv portatile] [http://reikofanel.ifrance.com/web/consulenza.htm consulenza 626] [http://asing-argirl.ifrance.com/images/small/pasqua-toscana/ pasqua toscana] [http://hethrfethr77.ifrance.com/content/view/google-cl/ google cl] [http://soundwave106.ifrance.com/resources/articles/ufficio-rho/ ufficio rho] [http://bladiblada.ifrance.com/resources/articles/coppie-con.htm coppie con numeri di telefono] [http://alvonina.ifrance.com/img/styles/ijen-martin/ ijen martin] [http://soundwave106.ifrance.com/resources/articles/clonecd/ clonecd 4] [http://reikofanel.ifrance.com/web/download-music.htm download music vedio] [http://reikofanel.ifrance.com/web/last-minute.htm last minute pantelleria] [http://sarah531.ifrance.com/lib/lavastoviglie-ariston.htm lavastoviglie ariston 87] [http://dgdeeper.ifrance.com/img/styles/impastatrici-farina.htm impastatrici farina] [http://faithib.ifrance.com/description/lib/barth-theodor.htm barth theodor] [http://bang-sigh.ifrance.com/images/small/tariffe-telecom/ tariffe telecom] [http://reikofanel.ifrance.com/web/chad-kroeger.htm chad kroeger hero] [http://toupheefee.ifrance.com/text/directory/come-cocos/ come cocos] [http://kiravina.ifrance.com/html/caricatore-cd.htm caricatore cd autoradio mp3] [http://bang-sigh.ifrance.com/images/small/fotomontaggi-gratis/ fotomontaggi gratis di donne celebri] [http://nettikyzarc.ifrance.com/content/view/pazza/ pazza] [http://hethrfethr77.ifrance.com/content/view/cornelius-hogan/ cornelius hogan] [http://hethrfethr77.ifrance.com/content/view/matrix-screensaver/ matrix screensaver] [http://mania555.ifrance.com/img/styles/galaga.htm galaga] [http://mania555.ifrance.com/img/styles/baglioni-live.htm baglioni live] [http://alvonina.ifrance.com/img/styles/noleggio-dvd/ noleggio dvd trame film] [http://reikofanel.ifrance.com/web/bobbit.htm bobbit] [http://bladiblada.ifrance.com/resources/articles/slp.htm slp] [http://asing-argirl.ifrance.com/images/small/casalinghe-troie/ casalinghe troie] [http://bladiblada.ifrance.com/resources/articles/www-embassy.htm www embassy] [http://hethrfethr77.ifrance.com/content/view/filologia-classica/ filologia classica] [http://bladiblada.ifrance.com/resources/articles/la-da.htm la da delle streghe] [http://asing-argirl.ifrance.com/images/small/raian/ raian] [http://kirizz.ifrance.com/html/www-todo.htm www todo juego com] [http://dgdeeper.ifrance.com/img/styles/codice-telecomando.htm codice telecomando visa] [http://toupheefee.ifrance.com/text/directory/asus-ansli/ asus a8nsli nforce4] [http://reikofanel.ifrance.com/web/blastbilliard.htm blastbilliard] [http://toupheefee.ifrance.com/text/directory/toner-ml/ toner ml1510] [http://reikofanel.ifrance.com/web/not-in.htm not in love enrique eglesias] [http://bladiblada.ifrance.com/resources/articles/stampante-canon.htm stampante canon cp 500] [http://soundwave106.ifrance.com/resources/articles/fujitsu-lcd/ fujitsu lcd 172] [http://blackblackblack.ifrance.com/lib/tiscali-annuncio.htm tiscali annuncio case vacanza] [http://bang-sigh.ifrance.com/images/small/www-speed/ www speed up it] [http://crazybird027.ifrance.com/view/new/gabby-yorath/ gabby yorath] [http://hethrfethr77.ifrance.com/content/view/loredana-di/ loredana di cicco] [http://toupheefee.ifrance.com/text/directory/www-ministero/ www ministero istruzione padova] [http://mania555.ifrance.com/img/styles/tissot-orologio.htm tissot orologio] [http://sarah531.ifrance.com/lib/date-gf.htm date gf5] [http://csmith06.ifrance.com/lib/zond.htm zond] [http://bang-sigh.ifrance.com/images/small/scarpe-adidas/ scarpe adidas calcio] [http://sarah531.ifrance.com/lib/dvd-tdk.htm dvd tdk cd e vergini] [http://alvonina.ifrance.com/img/styles/drug/ drug] [http://mania555.ifrance.com/img/styles/il-ritorno.htm il ritorno degli ewoks] [http://faithib.ifrance.com/description/lib/franchising-forus.htm franchising forus campania (regione campania)] [http://kirizz.ifrance.com/html/calendario-.htm calendario 2005 reggiane] [http://asing-argirl.ifrance.com/images/small/d-avena/ d avena mp3] [http://crazybird027.ifrance.com/view/new/hokey-da/ hokey da tavolo] [http://faithib.ifrance.com/description/lib/acer.htm acer 2021] [http://faithib.ifrance.com/description/lib/rsmmc-per.htm rsmmc per nokia] [http://dgdeeper.ifrance.com/img/styles/jane-addiction.htm jane addiction] [http://itsmeladuh.ifrance.com/content/view/hotel-lignano/ hotel lignano] [http://soundwave106.ifrance.com/resources/articles/britny-spears/ britny spears toxic] [http://twobit77.ifrance.com/description/lib/giochi-gameboy/ giochi gameboy] [http://nettikyzarc.ifrance.com/content/view/sito-di/ sito di belli e brutti] [http://hethrfethr77.ifrance.com/content/view/mada-valgo/ mada valgo sin tu amor] [http://twobit77.ifrance.com/description/lib/meggy/ meggy] [http://dgdeeper.ifrance.com/img/styles/zhejiang.htm zhejiang] [http://crazybird027.ifrance.com/view/new/incantesimi-del/ incantesimi del libro delle ombre] [http://asing-argirl.ifrance.com/images/small/free-porno/ free porno 3x2] [http://dgdeeper.ifrance.com/img/styles/raid-.htm raid 5 sata] [http://bang-sigh.ifrance.com/images/small/abba-super/ abba super troupers] [http://mania555.ifrance.com/img/styles/panis-angelicus.htm panis angelicus di haendel] [http://toupheefee.ifrance.com/text/directory/era-paleozoica/ era paleozoica] [http://crazybird027.ifrance.com/view/new/masterp/ masterp] [http://faithib.ifrance.com/description/lib/obiettivi-telecamere.htm obiettivi telecamere] [http://itsmeladuh.ifrance.com/content/view/netmeeting/ netmeeting] [http://csmith06.ifrance.com/lib/ehi-lady.htm ehi lady] [http://asing-argirl.ifrance.com/images/small/tutt/ tutt] [http://mania555.ifrance.com/img/styles/mariah-carey.htm mariah carey] [http://twobit77.ifrance.com/description/lib/mu-immortal/ mu immortal] [http://bladiblada.ifrance.com/resources/articles/cavoli-tuoi.htm cavoli tuoi] [http://bladiblada.ifrance.com/resources/articles/bernazzoli.htm bernazzoli] [http://alvonina.ifrance.com/img/styles/kit-affilare/ kit affilare coltelli] [http://crazybird027.ifrance.com/view/new/i-vinti/ i vinti] [http://mania555.ifrance.com/img/styles/cronometro-oregon.htm cronometro oregon scientific] [http://asing-argirl.ifrance.com/images/small/www-immobiliare/ www immobiliare ponte it] [http://blackblackblack.ifrance.com/lib/tiziano-ferro.htm tiziano ferro a chi mi dice] [http://twobit77.ifrance.com/description/lib/golf-iv/ golf iv 25 years] [http://reikofanel.ifrance.com/web/prestito-lucca.htm prestito lucca] [http://nettikyzarc.ifrance.com/content/view/apple-i/ apple i pod accessori] [http://bang-sigh.ifrance.com/images/small/mingaladon/ mingaladon] [http://faithib.ifrance.com/description/lib/polar-cs.htm polar cs 200 cad] [http://bang-sigh.ifrance.com/images/small/voli-per/ voli per sharm el sheikh] [http://kiravina.ifrance.com/html/lexus-rx.htm lexus rx 400] [http://alvonina.ifrance.com/img/styles/krzysztof-cieciuch/ krzysztof cieciuch] [http://hethrfethr77.ifrance.com/content/view/la-tratta/ la tratta delle bianche] [http://blackblackblack.ifrance.com/lib/mp-thomson.htm mp3 thomson lyra 20gb] [http://crazybird027.ifrance.com/view/new/iomega-desktop/ iomega desktop hdd usb 2 0 200gb] [http://blackblackblack.ifrance.com/lib/incontro-arezzo.htm incontro arezzo] [http://nettikyzarc.ifrance.com/content/view/videoclip-eifel/ videoclip eifel 65] [http://faithib.ifrance.com/description/lib/foto-di.htm foto di orietta berti] [http://hethrfethr77.ifrance.com/content/view/viaggi-abruzzo/ viaggi abruzzo] [http://toupheefee.ifrance.com/text/directory/some-many/ some many times] [http://itsmeladuh.ifrance.com/content/view/venus-srl/ venus srl] [http://alvonina.ifrance.com/img/styles/il-primo/ il primo gamecube arriva in america] [http://hethrfethr77.ifrance.com/content/view/scherzi-per/ scherzi per pc] {{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 12:28, 1 September 2007

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