Table creation: Difference between revisions

From Rosetta Code
Content added Content deleted
(revert spam)
mNo edit summary
Line 1: Line 1:
[http://morudd.angelfire.com/web/tu-mi/ tu mi doni questo giorno] [http://vegrigsb.angelfire.com/resources/sin-bandera.htm sin bandera mientes tambien] [http://anethel.angelfire.com/campc.htm cam2pc] [http://hoadmoni.125mb.com/styles/trouveras/ trouveras] [http://nescogin.125mb.com/content/verdissima.htm verdissima] [http://yarobiso.angelfire.com/text/soluzione-maturita.htm soluzione maturita geometri it] [http://sibeatri.angelfire.com/html/missing-in/ missing in action 2 chuck norris film] [http://champ-alnite.angelfire.com/simone-video.htm simone video] [http://woharwoo.angelfire.com/data/campionato-calcio/ campionato calcio serie c1] [http://dacornel.125mb.com/data/giradischi.htm giradischi] [http://ruwier.125mb.com/pliohippus/ pliohippus] [http://champ-alnite.angelfire.com/kal-ho.htm kal ho na] [http://requidim.angelfire.com/web/mp-gb.htm mp3 20gb] [http://bedrew.125mb.com/homeportal.htm homeportal] [http://dleslis.125mb.com/resources/michelle-vieth.htm michelle vieth nude] [http://sibeatri.angelfire.com/html/telit-gu/ telit gu1100] [http://tibrown.125mb.com/description/lg-gsab/ lg gsa4165b] [http://sawilson.125mb.com/data/www-divididos.htm www divididos com ar] [http://bedrew.125mb.com/gamba-collant.htm gamba collant] [http://sewehner.125mb.com/articles/spartherm/ spartherm] [http://dleslis.125mb.com/resources/the-rasmus.htm the rasmus in the shadows] [http://mamans.125mb.com/topic/seca-hex.htm seca hex files] [http://degaylor.125mb.com/cfsdf/ cfsdf] [http://sawilson.125mb.com/data/jvc-mc.htm jvc mc200] [http://blhestrie.125mb.com/web/bisex-vicenza/ bisex vicenza] [http://vegrigsb.angelfire.com/resources/acer-travelmate.htm acer travelmate serie 3000] [http://awihimmeru.angelfire.com/spyware-remover.htm spyware remover] [http://blhestrie.125mb.com/web/cuffie-per/ cuffie per cordless] [http://kocarawf.125mb.com/blog/cel.htm cel] [http://bedrew.125mb.com/annunci-erotici.htm annunci erotici o di sesso di casalinghe] [http://mamans.125mb.com/topic/testo-di.htm testo di shakira] [http://nescogin.125mb.com/content/camera-carrara.htm camera carrara] [http://requidim.angelfire.com/web/sotware-nec.htm sotware nec e313 usb] [http://nescogin.125mb.com/content/www-prada.htm www prada com] [http://slavfondmeister.angelfire.com/styles/testo-leali.htm testo leali] [http://dleslis.125mb.com/resources/nvidia-geforce.htm nvidia geforce 6600 256mb agp] [http://anethel.angelfire.com/nu-sinh.htm nu sinh ngo quyen] [http://amarymuk.angelfire.com/html/patentino-ciclomotori.htm patentino ciclomotori maggiorenni] [http://slavfondmeister.angelfire.com/styles/www-agujero.htm www agujero negro] [http://sawilson.125mb.com/data/il-magico.htm il magico mondo di winnie the pooh mille giochi con pooh] [http://kocarawf.125mb.com/blog/memorie-flash.htm memorie flash usb] [http://grdugans.angelfire.com/text/dikom-secure.htm dikom secure] [http://sawilson.125mb.com/data/sintoamplificatore-senza.htm sintoamplificatore senza fili] [http://bedrew.125mb.com/mondeo-.htm mondeo 2 0 sw ghia] [http://kocarawf.125mb.com/blog/ml.htm ml 4500] [http://vegrigsb.angelfire.com/resources/caraibi-viaggio.htm caraibi viaggio] [http://dleslis.125mb.com/resources/eva-longoria.htm eva longoria] [http://hahosmer.angelfire.com/html/marko-miglia.htm marko miglia] [http://hahosmer.angelfire.com/html/calciio.htm calciio] [http://dacornel.125mb.com/data/finizio-gigi.htm finizio gigi] [http://sewehner.125mb.com/articles/bt-dg/ bt dg03] [http://yarobiso.angelfire.com/text/www-pinkworld.htm www pinkworld it] [http://dacornel.125mb.com/data/hotel-santander.htm hotel santander] [http://bedrew.125mb.com/video-laura.htm video laura] [http://slavfondmeister.angelfire.com/styles/pianura.htm pianura] [http://slavfondmeister.angelfire.com/styles/testi-antonacci.htm testi antonacci biagio] [http://champ-alnite.angelfire.com/il-testo.htm il testo di a chi mi dice] [http://stjollay.125mb.com/topic/hp-compaq/ hp compaq nx6110 512 mb] [http://wiellico.125mb.com/html/lucio-battisti.htm lucio battisti la canzone del sole] [http://kocarawf.125mb.com/blog/hd-.htm hd 15000 rpm] [http://ruwier.125mb.com/incoming-forces/ incoming forces] [http://degaylor.125mb.com/lamore-e/ lamore e altre catastrofi] [http://dleslis.125mb.com/resources/gli-scarafaggi.htm gli scarafaggi oh] [http://awihimmeru.angelfire.com/pescari.htm pescari] [http://blhestrie.125mb.com/web/www-ilsoleore/ www ilsole24ore com] [http://ruwier.125mb.com/dragostea-din/ dragostea din tei lyrics] [http://wiellico.125mb.com/html/quand-est.htm quand est ce sainte yvonne] [http://sawilson.125mb.com/data/discoteca-otel.htm discoteca otel] [http://mamans.125mb.com/topic/lg-rh.htm lg rh7800] [http://hahosmer.angelfire.com/html/x-type.htm x type] [http://paryker.125mb.com/styles/prgramy/ prgramy] [http://kocarawf.125mb.com/blog/pagina-personale.htm pagina personale] [http://tibrown.125mb.com/description/estate/ estate 2001] [http://sewehner.125mb.com/articles/rock-n/ rock n roll robot] [http://awihimmeru.angelfire.com/occhi-sul.htm occhi sul delitto] [http://dleslis.125mb.com/resources/schaub-lorenz.htm schaub lorenz microonde] [http://nescogin.125mb.com/content/donne-bologna.htm donne bologna] [http://mamans.125mb.com/topic/rovera-stepper.htm rovera stepper] [http://ruwier.125mb.com/www-loredana/ www loredana it] [http://tibrown.125mb.com/description/linksys-wkpcg/ linksys wkpc54g] [http://wiellico.125mb.com/html/ricetrasmittente-pmr.htm ricetrasmittente pmr] [http://mamans.125mb.com/topic/levriero.htm levriero] [http://kocarawf.125mb.com/blog/elettrostimolatore-facciale.htm elettrostimolatore facciale] [http://blhestrie.125mb.com/web/mia-moglie/ mia moglie nuda] [http://stjollay.125mb.com/topic/fischia-il/ fischia il sesso] [http://sawilson.125mb.com/data/fura.htm fura] [http://ruwier.125mb.com/foppapedretti-mobile/ foppapedretti mobile stiro] [http://stjollay.125mb.com/topic/canon-borsa/ canon borsa] [http://sewehner.125mb.com/articles/carsten/ carsten] [http://gistrate.angelfire.com/html/hp-officejet.htm hp officejet 7310 allinone] [http://kocarawf.125mb.com/blog/home-theatre.htm home theatre bose 2 1] [http://fikimber.125mb.com/lib/gisele-bunchen.htm gisele bunchen biografia] [http://awihimmeru.angelfire.com/nikolas-berg.htm nikolas berg] [http://requidim.angelfire.com/web/marina-service.htm marina service residence] [http://sewehner.125mb.com/articles/incesto-hard/ incesto hard] [http://bedrew.125mb.com/tre-ostaggi.htm tre ostaggi] [http://fikimber.125mb.com/lib/katie-jordan.htm katie jordan price video] [http://wiellico.125mb.com/html/orni.htm orni] [http://champ-alnite.angelfire.com/xg-konica.htm xg konica minolta] [http://stjollay.125mb.com/topic/game-iso/ game iso] [http://paryker.125mb.com/styles/concessionario-toyota/ concessionario toyota roma] [http://gitedy.125mb.com/blog/investimento-corea/ investimento corea] [http://degaylor.125mb.com/battisti-si/ battisti si viaggiare] [http://bedrew.125mb.com/interviste-rai.htm interviste rai due 1 settembre] [http://awihimmeru.angelfire.com/flex-magazine.htm flex magazine] [http://dleslis.125mb.com/resources/spycam-gratis.htm spycam gratis] [http://dleslis.125mb.com/resources/indonesia-cose.htm indonesia cose fare] [http://bedrew.125mb.com/box-per.htm box per hard disk esterni] [http://ruwier.125mb.com/batterie-videocamere/ batterie videocamere canon bp] [http://fikimber.125mb.com/lib/sl.htm sl 320] [http://gistrate.angelfire.com/html/vacanze-in.htm vacanze in marche] [http://sewehner.125mb.com/articles/canon-l/ canon l400] [http://mcclaise.angelfire.com/description/casetta-per/ casetta per bambino] [http://spdinnie.angelfire.com/html/generatore-carte/ generatore carte di credito] [http://woharwoo.angelfire.com/data/www-computer/ www computer ecdl data mese giorno it] [http://degaylor.125mb.com/oswiecim/ oswiecim] [http://yarobiso.angelfire.com/text/batterie-nokia.htm batterie nokia bl4c] [http://dacornel.125mb.com/data/ocean-camerun.htm ocean (camerun)] [http://gitedy.125mb.com/blog/tesine-ppt/ tesine ppt] [http://yarobiso.angelfire.com/text/schemi-elettrici.htm schemi elettrici mercedes] [http://hahosmer.angelfire.com/html/tettone-fica.htm tettone fica] [http://tibrown.125mb.com/description/piccolo-cuore/ piccolo cuore] [http://vegrigsb.angelfire.com/resources/huy.htm huy 82] [http://dacornel.125mb.com/data/porno-giapponesi.htm porno giapponesi] [http://gitedy.125mb.com/blog/janine/ janine] [http://bedrew.125mb.com/dmr-esv.htm dmr es30v] [http://nescogin.125mb.com/content/bambu-bambu.htm bambu bambu] [http://stjollay.125mb.com/topic/disegno-animale/ disegno animale colorare] [http://sewehner.125mb.com/articles/boccaccio-giovanni/ boccaccio giovanni] [http://stjollay.125mb.com/topic/mattioli/ mattioli] [http://dacornel.125mb.com/data/garand.htm garand] [http://mamans.125mb.com/topic/foto-gratis.htm foto gratis brad pitt] [http://morudd.angelfire.com/web/the-used/ the used] [http://sawilson.125mb.com/data/nikon.htm nikon 85] [http://degaylor.125mb.com/dic/ dic] [http://blhestrie.125mb.com/web/fuji-finepix/ fuji finepix] [http://wiellico.125mb.com/html/risultati-partite.htm risultati partite calcio diretta] [http://wiellico.125mb.com/html/cabiria-e.htm cabiria e il suo tempo] [http://hoadmoni.125mb.com/styles/desafio/ desafio] [http://ruwier.125mb.com/cuffie-professionali/ cuffie professionali] [http://stjollay.125mb.com/topic/in-nuce/ in nuce] [http://dacornel.125mb.com/data/government-issue.htm government issue live 1985] [http://hoadmoni.125mb.com/styles/stephen-king/ stephen king misery] [http://yarobiso.angelfire.com/text/alban-berg.htm alban berg woyzeck] [http://stjollay.125mb.com/topic/jaded-greenday/ jaded greenday] [http://sewehner.125mb.com/articles/end-ol/ end ol life] [http://sibeatri.angelfire.com/html/grupos-de/ grupos de axe] [http://wiellico.125mb.com/html/husher.htm husher] [http://stjollay.125mb.com/topic/nikkor-dx/ nikkor dx] [http://ruwier.125mb.com/romances-del/ romances del ruido] [http://ruwier.125mb.com/agenzia-immobiliare/ agenzia immobiliare pescara] [http://dleslis.125mb.com/resources/itazura-na.htm itazura na kiss] [http://grdugans.angelfire.com/text/pc-hp.htm pc2100 hp] [http://bedrew.125mb.com/repubblica-san.htm repubblica san marino] [http://morudd.angelfire.com/web/media-center/ media center pentium] [http://degaylor.125mb.com/recupero-scuola/ recupero scuola] [http://dleslis.125mb.com/resources/muvo-tx.htm muvo tx 256mb] [http://fikimber.125mb.com/lib/legge-.htm legge 448 del 28 12 2001] [http://sewehner.125mb.com/articles/philips-key/ philips key ring 128mb] [http://degaylor.125mb.com/camera-mogliano/ camera mogliano veneto] [http://wiellico.125mb.com/html/libro-elettronico.htm libro elettronico] [http://nescogin.125mb.com/content/ubbidire.htm ubbidire] [http://sibeatri.angelfire.com/html/denzel-pump/ denzel pump it] [http://nescogin.125mb.com/content/senigallia.htm senigallia] [http://bedrew.125mb.com/bigliettini-da.htm bigliettini da visita] [http://dacornel.125mb.com/data/sadismo.htm sadismo] [http://mcclaise.angelfire.com/description/leica-c/ leica c2] [http://dleslis.125mb.com/resources/babbo-natale.htm babbo natale in laponia] [http://mcclaise.angelfire.com/description/lee-ryan/ lee ryan it] [http://blhestrie.125mb.com/web/schede-grafiche/ schede grafiche ati 9200] [http://dacornel.125mb.com/data/giava.htm giava] [http://gitedy.125mb.com/blog/cybershot-p/ cybershot p200] [http://blhestrie.125mb.com/web/nuovo-sigma/ nuovo sigma 28300mm] [http://mamans.125mb.com/topic/roberto-cavalli.htm roberto cavalli abiti donna] [http://hoadmoni.125mb.com/styles/lestate-di/ lestate di mio fratello] [http://sawilson.125mb.com/data/albairate.htm albairate] [http://bedrew.125mb.com/lettore-dvd.htm lettore dvd interno] [http://yonosoyyo.angelfire.com/directory/air-line.htm air line 69] [http://gistrate.angelfire.com/html/metroid-zero.htm metroid zero mission trucchi] [http://morudd.angelfire.com/web/gps-mio/ gps mio 269] [http://blhestrie.125mb.com/web/donatella-milani/ donatella milani] [http://paryker.125mb.com/styles/banana-boat/ banana boat song] [http://morudd.angelfire.com/web/anello-con/ anello con diamanti] [http://bedrew.125mb.com/cavo-firewire.htm cavo firewire 800] [http://degaylor.125mb.com/mentone-alberghi/ mentone alberghi e hotel] [http://champ-alnite.angelfire.com/yashal.htm yashal] [http://mamans.125mb.com/topic/fotoracconti-hard.htm fotoracconti hard] [http://kocarawf.125mb.com/blog/nude-ragaze.htm nude ragaze] [http://mamans.125mb.com/topic/tv-lcd.htm tv lcd con lettore dvd integrato] [http://sewehner.125mb.com/articles/giochi-non/ giochi non adatti ai bambini] [http://bedrew.125mb.com/asics-duomax.htm asics duomax] [http://stjollay.125mb.com/topic/jameson-jenna/ jameson jenna] [http://grdugans.angelfire.com/text/link-keith.htm link keith maupin] [http://blhestrie.125mb.com/web/alfa-gtv/ alfa gtv] [http://requidim.angelfire.com/web/aficio-cl.htm aficio cl 7000] [http://gitedy.125mb.com/blog/cubo-rubik/ cubo rubik] [http://stjollay.125mb.com/topic/batterie-nokia/ batterie nokia 9500] [http://mamans.125mb.com/topic/nove-immagini.htm nove immagini per ghost in the shell] [http://kocarawf.125mb.com/blog/pooh-io.htm pooh io ti aspettero] [http://dacornel.125mb.com/data/bet.htm bet] {{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 04:13, 30 August 2007

tu mi doni questo giorno sin bandera mientes tambien cam2pc trouveras verdissima soluzione maturita geometri it missing in action 2 chuck norris film simone video campionato calcio serie c1 giradischi pliohippus kal ho na mp3 20gb homeportal michelle vieth nude telit gu1100 lg gsa4165b www divididos com ar gamba collant spartherm the rasmus in the shadows seca hex files cfsdf jvc mc200 bisex vicenza acer travelmate serie 3000 spyware remover cuffie per cordless cel annunci erotici o di sesso di casalinghe testo di shakira camera carrara sotware nec e313 usb www prada com testo leali nvidia geforce 6600 256mb agp nu sinh ngo quyen patentino ciclomotori maggiorenni www agujero negro il magico mondo di winnie the pooh mille giochi con pooh memorie flash usb dikom secure sintoamplificatore senza fili mondeo 2 0 sw ghia ml 4500 caraibi viaggio eva longoria marko miglia calciio finizio gigi bt dg03 www pinkworld it hotel santander video laura pianura testi antonacci biagio il testo di a chi mi dice hp compaq nx6110 512 mb lucio battisti la canzone del sole hd 15000 rpm incoming forces lamore e altre catastrofi gli scarafaggi oh pescari www ilsole24ore com dragostea din tei lyrics quand est ce sainte yvonne discoteca otel lg rh7800 x type prgramy pagina personale estate 2001 rock n roll robot occhi sul delitto schaub lorenz microonde donne bologna rovera stepper www loredana it linksys wkpc54g ricetrasmittente pmr levriero elettrostimolatore facciale mia moglie nuda fischia il sesso fura foppapedretti mobile stiro canon borsa carsten hp officejet 7310 allinone home theatre bose 2 1 gisele bunchen biografia nikolas berg marina service residence incesto hard tre ostaggi katie jordan price video orni xg konica minolta game iso concessionario toyota roma investimento corea battisti si viaggiare interviste rai due 1 settembre flex magazine spycam gratis indonesia cose fare box per hard disk esterni batterie videocamere canon bp sl 320 vacanze in marche canon l400 casetta per bambino generatore carte di credito www computer ecdl data mese giorno it oswiecim batterie nokia bl4c ocean (camerun) tesine ppt schemi elettrici mercedes tettone fica piccolo cuore huy 82 porno giapponesi janine dmr es30v bambu bambu disegno animale colorare boccaccio giovanni mattioli garand foto gratis brad pitt the used nikon 85 dic fuji finepix risultati partite calcio diretta cabiria e il suo tempo desafio cuffie professionali in nuce government issue live 1985 stephen king misery alban berg woyzeck jaded greenday end ol life grupos de axe husher nikkor dx romances del ruido agenzia immobiliare pescara itazura na kiss pc2100 hp repubblica san marino media center pentium recupero scuola muvo tx 256mb legge 448 del 28 12 2001 philips key ring 128mb camera mogliano veneto libro elettronico ubbidire denzel pump it senigallia bigliettini da visita sadismo leica c2 babbo natale in laponia lee ryan it schede grafiche ati 9200 giava cybershot p200 nuovo sigma 28300mm roberto cavalli abiti donna lestate di mio fratello albairate lettore dvd interno air line 69 metroid zero mission trucchi gps mio 269 donatella milani banana boat song anello con diamanti cavo firewire 800 mentone alberghi e hotel yashal fotoracconti hard nude ragaze tv lcd con lettore dvd integrato giochi non adatti ai bambini asics duomax jameson jenna link keith maupin alfa gtv aficio cl 7000 cubo rubik batterie nokia 9500 nove immagini per ghost in the shell pooh io ti aspettero bet

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