Search Postgresql Archives

Re: user defined function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux