You can use CREATE TYPE:
http://www.postgresql.org/docs/8.2/interactive/sql-createtype.html
Example from the documentation:
CREATE TYPE compfoo AS (f1 int, f2 text);
Then make your function return compfoo (or setof compfoo).
Alternately, you can define your function with out or in/out
parameters so you don't need the CREATE TYPE statement.
On May 11, 2007, at 10:42 AM, Gábriel Ákos wrote:
You might be looking for PostgreSQL RECORD data type.
Thanks. Give me an example please. I saw the documentation already.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
