Skip site navigation (1) Skip section navigation (2)

Composite Type Argument Construction to a Function

From: <tsarevich(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Composite Type Argument Construction to a Function
Date: 2004-09-29 08:34:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
create type my_type (my_test text, my_int integer);

create function my_function(my_type)
returns timestamp as
return (current_timestamp);
language 'plpgsql';

In 7.3.5, we are trying to get around the 32 argument limit of the
functions WITHOUT re-compiling with a greater func_max_args (due to
operational reasons).

My question is - HOW do I construct the argument to
my_function(my_type) so that the function recognises that I am passing
into it composite data?

NB:  The example function is just "junque" to test passing a composite
type to a function.



pgsql-general by date

Next:From: tsarevichDate: 2004-09-29 08:54:47
Subject: Re: Syntax Issue in Trigger Function??
Previous:From: Sim ZacksDate: 2004-09-29 08:32:23
Subject: sql script confusion

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group