From: | andrew <andrew(dot)ylzhou(at)gmail(dot)com> |
---|---|
To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: user defined function |
Date: | 2006-01-25 14:22:30 |
Message-ID: | 29d3b0b90601250622l4a2d0ac9hf52ca9be5b48c0d9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)g2switchworks(dot)com> wrote:
> On Tue, 2006-01-24 at 14:38, Tom Lane wrote:
> > Yl Zhou <andrew(dot)ylzhou(at)gmail(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | James Croft | 2006-01-25 15:01:24 | Re: Temporary table visibility |
Previous Message | Jaime Casanova | 2006-01-25 14:17:41 | Re: Temporary table visibility |