Re: [GENERAL] function accepting a row

2005-08-11 Thread Tomek Grzejszczyk
Michael Fuhr napisal(a): PL/pgSQL functions can *accept* these types of arguments, but in versions earlier than 8.0 they have trouble *passing* such arguments to another function. Now I get it. Thank you. Tomek Grzejszczyk ---(end of broadcast)---

Re: [GENERAL] function accepting a row

2005-08-11 Thread Michael Fuhr
On Thu, Aug 11, 2005 at 12:20:17PM +0200, tgrzej wrote: > I tried to follow #37.1.2 from: > http://www.postgresql.org/docs/7.4/interactive/plpgsql.html > > where one can read: > "Functions written in PL/pgSQL can accept as arguments any scalar or > array data type supported by the server, and they

Re: [GENERAL] function accepting a row

2005-08-11 Thread tgrzej
Od: Michael Fuhr <[EMAIL PROTECTED]> .. > * More support for composite types (row and record variables) in > PL/pgSQL > > For example, it now works to pass a rowtype variable to another > function as a single variable. > > If you're using a version older than 8.0 then you'll have to work > with

Re: [GENERAL] function accepting a row

2005-08-10 Thread Michael Fuhr
On Wed, Aug 10, 2005 at 08:01:13PM +0200, Tomek Grzejszczyk wrote: > I'am trying to create a function in plpgsql that will accept a parameter > of type rowtype. Here is a little test script I wrote: > http://62.121.81.182/pub/test_func.sql > > It works on Postgres 8.03, but fails on 7.4, where I