Re: How to set a Default Value

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

In response to

Responses

Browse pgsql-novice by date

  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';