Hmmm since the function already knows the type, the quotes aren't needed. If you use them it just inserts a literal $1 and $3.
----- Original Message ----- From: "Alex Satrapa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 4:33 PM Subject: Re: [GENERAL] sql insert function > Chris Ochs wrote: > > Never mind, I forgot to quote the quote's... > > Heh... and here I was thinking you were trying to build a function ;) > > And I made the same mistake as you... guess I should proofread instead > of copy-pasting ;) > > Alex Satrapa > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
