Re: calling functions which take user defined types - Mailing list pgsql-novice

From Tom Lane
Subject Re: calling functions which take user defined types
Date
Msg-id 19612.1282746648@sss.pgh.pa.us
Whole thread Raw
In response to calling functions which take user defined types  (Siddharth Saha <siddharthsaha@drishti-soft.com>)
List pgsql-novice
Siddharth Saha <siddharthsaha@drishti-soft.com> writes:
> Can someone tell me how to invoke a UDF which takes a user-defined type as
> one of its arguments.

It's not significantly different from calling functions with built-in types.
Typically you'd do

    select myfunc('value', ...);

for a scalar type, or

    select myfunc(row('value', 'value', ...), ...);

for a composite type.

            regards, tom lane

pgsql-novice by date:

Previous
From: Siddharth Saha
Date:
Subject: calling functions which take user defined types
Next
From: "Carel Combrink"
Date:
Subject: Display XML Table output in Browser