Re: user defined function - Mailing list pgsql-general

From andrew
Subject Re: user defined function
Date
Msg-id 29d3b0b90601250622l4a2d0ac9hf52ca9be5b48c0d9@mail.gmail.com
Whole thread Raw
In response to Re: user defined function  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: user defined function
List pgsql-general
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@g2switchworks.com> wrote:
> On Tue, 2006-01-24 at 14:38, Tom Lane wrote:
> > Yl Zhou <andrew.ylzhou@gmail.com> 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.
>

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Temporary table visibility
Next
From: James Croft
Date:
Subject: Re: Temporary table visibility