The following is just copied from the screen. backend> create function foo(record) returns int4 as '$libdir/bar' language C QUERY: create function foo(record) returns int4 as '$libdir/bar' language C ERROR: parser: parse error at or near "record" at character 21 in Warn_restart code What is the problem here? Did you test it on 7.3? On 1/25/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > andrew <andrew.ylzhou@xxxxxxxxx> writes: > > I use 7.3 and use RECORD as the input data type of the function by > > "create function foo(record) returns int4 as '$libdir/bar' language > > C". But I got this error msg:" ERROR: parser: parse error at or near > > "record" at character". What is the problem? > > Sure you typed it correctly? I get > > regression=# create function foo(record) returns int4 as '$libdir/bar' language C; > ERROR: stat failed on file '$libdir/bar': No such file or directory > regression=# > > so it's getting past the parse-error stage here. > > regards, tom lane >