Composite Types and Function Parameters
Greg <grigorey@yahoo.co.uk>
From: Greg <grigorey@yahoo.co.uk>
To: pgsql-hackers@postgresql.org
Date: 2010-10-25T15:56:56Z
Lists: pgsql-hackers
Hi guys, got across an interesting problem of passing params to a function in postgre: is it possible to pass a composite parameter to a function without declaring a type first?
For example:
// declare a function
create function TEST ( object??? )
....
object???.paramName // using parameter
....
// calling
perform TEST( ROW(string, int, bool, etc...) )
Or do I have to do the type declaration for that parameter?
Thanks!