[GENERAL] Semi-Pseudo Data Types & Procedure Arguments

2013-06-26 Thread Joshua Burns
Has anyone played around with what I would call "Semi-Pseudo Data Types," in which a stored procedure may accept a sub-set of a Pseudo Data Types but not just any pseudo data-type, such as any type of string (text, character varying, character), any type of integer (smallint, integer, bigint), or a

[GENERAL] Odd behavior in functions w/ anyarray & anyelement

2013-09-11 Thread Joshua Burns
Greetings, I'm trying to track down some undocumented (or perhaps not well documented) behavior I'm encountering in regards to custom functions (in plpgsql) utilizing anyelement and anyarray as arguments and/or return types. I arrived at this point when I was attempting to write the function "ANY