Re: sql insert function

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" <alex@lintelsys.com.au>
To: <pgsql-general@postgresql.org>
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
>