Rich, > That was my thought - I was fairly sure I fixed it though..... Do, really > need to be specific in terms of type in terms of int, or can I put numeric,
INT and numeric are fairly different, and I believe that SRF return types are very fussy about data types; I wouldn't be surprised if you got an error for using an INT4 in place of an INT8. > and for varchar(30) I can just put varchar in my type definition. That I don't think will be a problem; varchar limits are indifferently supported anyway. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html