From: | Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br> |
---|---|
To: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to set a Default Value |
Date: | 2006-01-13 17:40:25 |
Message-ID: | 20060113174026.73803.qmail@web36704.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
My table definition (i change the deafult to 'N') :
CREATE TABLE pautaitem
(
cdpautaitem serial NOT NULL,
arquivo varchar(255),
item varchar(255),
cdpauta varchar(255),
cditem varchar(11) NOT NULL DEFAULT 'N',
CONSTRAINT pauta_arquivos_pkey PRIMARY KEY
(cdpautaitem)
)
My insert query:
INSERT INTO PautaItem (
CdPauta,
Item,
CdItem,
Arquivo) VALUES (
'"+this.sCdPauta',
'"+this.sItem',
'"+this.sCdItem',
'"+this.sArqImagem')
Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo(at)yahoo(dot)com(dot)br
_______________________________________________________
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-01-13 18:29:54 | Re: How to set a Default Value |
Previous Message | Christian Hofmann | 2006-01-13 15:39:22 | User variables like: SET @a='test'; |