pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jens Hartwig <jhartwig@debis.com>
To: guard <guard@ficnet.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: create default
Date: Mon, 08 Jan 2001 08:49:10 +0100
Message-ID: <3A5970F6.95DA47AD@debis.com> (raw)
References: <9397o9$qlf$1@news.tht.net>

> 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

Try the following:

CREATE FUNCTION test() RETURNS opaque AS
    'BEGIN
        IF new.cno1 IS NULL THEN
            IF new.cno2 IS NULL THEN
                new.cno1 := substr(new.cno3,1,3); 
            ELSIF new.cno3 IS NULL THEN
                new.cno1 := substr(new.cno2,1,3); 
            ELSE
                new.cno1 := substr(new.cno2,1,3)||substr(new.cno3,1,3);
            END IF;
        END IF;
        RETURN new;
     END;'
LANGUAGE 'plpgsql';

CREATE TRIGGER test_trg
BEFORE INSERT OR UPDATE ON table1
FOR EACH ROW
EXECUTE PROCEDURE test();

INSERT INTO table1 (cno2, cno3) values ('abc', 'def');

SELECT * FROM table1;

Best regards, Jens Hartwig

=============================================
Jens Hartwig
---------------------------------------------
debis Systemhaus GEI mbH
10875 Berlin
Tel.     : +49 (0)30 2554-3282
Fax      : +49 (0)30 2554-3187
Mobil    : +49 (0)170 167-2648
E-Mail   : jhartwig@debis.com
=============================================



view thread (3+ messages)  latest in thread

Message-ID: <3A5970F6.95DA47AD@debis.com>
Permalink:  ../3A5970F6.95DA47AD@debis.com/
Also on:    postgresql.org/message-id/3A5970F6.95DA47AD@debis.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jhartwig@debis.com, guard@ficnet.net
  Subject: Re: create default
  In-Reply-To: <3A5970F6.95DA47AD@debis.com>
  References: <9397o9$qlf$1@news.tht.net> <3A5970F6.95DA47AD@debis.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox