Re: Composite Type Argument Construction to a Function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tsarevich(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Composite Type Argument Construction to a Function
Date: 2004-09-29 16:28:02
Message-ID: 182.1096475282@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<tsarevich(at)gmail(dot)com> writes:
> 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?

Sorry, don't think you're going to have much joy on that in 7.3.

In 8.0 you could do it with a ROW() constructor, but there's no such
thing in 7.3. IIRC the only way to pass a row value as a function
argument in 7.3 is to select the row from a table, viz

select my_function(t.*) from some_table t;

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-09-29 16:44:33 Re: string is sometimes null ?
Previous Message Net Virtual Mailing Lists 2004-09-29 16:10:35 Re: Postgres inherited table, some questions...