Re: [SQL] create default

2001-01-07 Thread 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 ne

[SQL] create default

2001-01-07 Thread 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: [HACKERS] md5 c code

2001-01-07 Thread 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