This was very helpfull. Thank you Craig > On Thu, Jan 13, 2005 at 07:58:33PM +0200, Craig Bryden wrote: > >> When I run select * from GetAccountInfo (100) I get the following >> error message: >> ERROR: a column definition list is required for functions returning >> "record" > > If the function will always return the same row type then create a > composite type with CREATE TYPE and return that instead of RECORD. > >> please can someone explain to me how to create a column definition list. > > See the documentation for SELECT in the Reference part of the > PostgreSQL documentation; the Examples section shows a query with > a column definition list. But you won't need a column definition > list if you return a known type instead of RECORD. > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
