Re: Creating a function that acept any data type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alejandro Michelin Salomon \( Adinet \)" <alejmsg(at)adinet(dot)com(dot)uy>
Cc: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creating a function that acept any data type
Date: 2006-03-10 20:44:45
Message-ID: 14351.1142023485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Alejandro Michelin Salomon \( Adinet \)" <alejmsg(at)adinet(dot)com(dot)uy> writes:
> Can you help-me to create a function that acept any data type ?

Use ANYELEMENT, not ANY. Also I'd suggest making it a SQL function not
a plpgsql function, so that it can be inlined.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2006-03-10 20:45:11 Re: in Pl/PgSQL, do commit every 5000 records
Previous Message Michael Fuhr 2006-03-10 20:42:55 Re: Creating a function that acept any data type