PostgreSQL has this interesting placeholder called anyelement which it has had for a long time and its complement anyarray. They are used when you want to define a function that can handle many types arguments or can output many types of outputs. They are particularly useful for defining aggregates, which we demonstrated in Who’s on First and Who’s on Last and several other aggregate articles.
Anyelement / anyarray can be used just as conveniently in other functions. The main gotcha is that when you pass in the first anyelement/anyarray all subsequent anyelement / anyarray must match the same data type as the first anyelement / anyarray.Mas:

http://www.postgresonline.com/journal/archives/239-The-wonders-of-Any-Element.html

Post comment

*

Buscar en DbRunas

Descargar versiones libres recomendadas actualizadas

Revistas

PostgreSQL Magazine (ingles): PostgreSQL Magazine
SQL Server (ingles): SolidQ SQL Server Journal
SQL Server (ingles): Code Magazine
PostgreSQL (ingles): Postgres OnLine Journal
Oracle (ingles): oraclemagazine-digital
SQL Server (español): MSDN Magazine
MySQL (ingles): MySQL Magazine

Manuales

Recursos

Archivo diario de noticias

January 2012
M T W T F S S
« Dec   Feb »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Archivo por mes y año

Comentarios recientes

RSS Ayudas Oracle

RSS Ayudas PostgreSQL

RSS Ayudas MySQL

RSS Ayudas SQL Server

RSS Ayudas DB2

RSS Ayudas SQL

RSS Feeds Planeta PostgreSQL-es

RSS Feeds Planet PostgreSQL

RSS Feeds Planeta PostgreSLQ Brazil

RSS Feeds Planet MySQL

Blogroll

Clouds

Desde donde nos visitan

Site5 | Experts In Reseller Hosting.