On Saturday 01 July 2006 09:08, "Alain Roger" <[EMAIL PROTECTED]> wrote: > it works but i get all fields from my accounts table. > > So how can i get only login and status ? >
Define a composite type that includes only those fields and return SETOF that_new_type instead of SETOF accounts. Or select login,status from function_name() instead of select *. -- When we vote for taxes, we are voting to steal from our neighbors ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings