Re: [HACKERS] md5 c code

[Marko Kreen]

On Thu, Jan 04, 2001 at 04:24:18PM -0500, Ron Peterson wrote:
> I've attached a bit of c code to do md5 checksums on text.  There's

Check contrib/pgcrypto in 7.1/CVS

-- 
marko

[SQL] create default

[guard]

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

Re: [SQL] create default

[Jens Hartwig]

> 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   : [EMAIL PROTECTED]
=