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

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 (view raw or flat)
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

pgsql-general by date

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

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