create default

From: "guard" <guard(at)ficnet(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: create default
Date: 2001-01-07 08:10:25
Message-ID: 9397o9$qlf$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi,how to set default filed+field

create table "table1"(
"cno1" char(10) default NEW.cno2+NEW.cno3,
"cno2" char(10) ,
"cno3" char(10)
);

I try pl/pgsql and pl/tcl NOT RUN,

thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marko Kreen 2001-01-07 11:32:27 Re: md5 c code
Previous Message Philip Warner 2001-01-07 07:55:44 Re: Re: [SQL] renaming columns... danger?