From: | "Chris Ochs" <chris(at)paymentonline(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: sql insert function |
Date: | 2004-01-13 00:44:51 |
Message-ID: | 025901c3d96e$7476f990$250a8b0a@chris |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)lintelsys(dot)com(dot)au>
To: <pgsql-general(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thapliyal, Deepak | 2004-01-13 00:48:38 | Re: Parse error help needed... |
Previous Message | Doug McNaught | 2004-01-13 00:44:18 | Re: Parse error help needed... |