Search Postgresql Archives

Re: user defined function

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

 



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? I look up the 7.3
manual. it seems record is a supported pseudo data type.

On 1/24/06, Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> wrote:
> On Tue, 2006-01-24 at 14:38, Tom Lane wrote:
> > Yl Zhou <andrew.ylzhou@xxxxxxxxx> writes:
> > > But I have to use 7.3 due to some limitations. Can I do it in 7.3?
> >
> > Probably, but I forget how (and I can guarantee that it will break
> > when you do move to 8.0 or later, because we changed the internal
> > representation of rowtype arguments).  You'd be *much* better off to
> > spend your time fixing whatever it is that's keeping you on 7.3.
>
> For some reason I'm remember 7.4 as being the first version that let you
> do this.  Not for certain.  I didn't run 7.3 in production though, so I
> might have missed it if it could do this.
>


[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