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@sss.pgh.pa.us> wrote:
> andrew <andrew.ylzhou@gmail.com> 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
>
