Re: user defined function

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> andrew <andrew(dot)ylzhou(at)gmail(dot)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
>