Re: sql insert function

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
>

In response to

Responses

Browse pgsql-general by date

  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...