Ahhh. Yes. A nasty typo. I did a global search for %1, %2, %3, etc. and turned up several elsewhere. Ouch. Thank you for your close reading.
== Ezra Epstein "Tom Lane" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "ezra epstein" <[EMAIL PROTECTED]> writes: > > IF NOT EXISTS(SELECT 1 FROM merchandise.ds_item($1) WHERE "client_key" = > > $2) THEN > > [ works, but this doesn't: ] > > SELECT INTO rec * FROM merchandise.ds_item($1) WHERE "client_key" = %2; > > If that's an accurate transcription, then your error is using %2 where > you meant $2. > > regards, tom lane > > ---------------------------(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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
