"Henry Combrinck" <[EMAIL PROTECTED]> writes: > Can you give an example of what a "named rowtype" is?
The result of CREATE TYPE AS, or the row type implicitly created for a table. For instance CREATE TYPE complex AS (r float, i float); CREATE FUNCTION abs(complex) RETURNS float AS ... or CREATE TABLE users (name text, ...); CREATE FUNCTION foobar(users) RETURNS ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match