Ow Mun Heng wrote: > On Mon, 2007-09-24 at 02:31 -0400, Alvaro Herrera wrote: > > > it ERRORs w/ could not determine data type of parameter $3 > > > > Cast it to the correct type. > > how do I cast a NULL? Is it Varchar? I didn't say "pick a random datatype", I said "the correct type", which in this case means the type "code" has in the function. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster