Re: sql insert function - Mailing list pgsql-general

From Chris Ochs
Subject Re: sql insert function
Date
Msg-id 025901c3d96e$7476f990$250a8b0a@chris
Whole thread Raw
In response to sql insert function  ("Chris Ochs" <chris@paymentonline.com>)
List 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@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
>


pgsql-general by date:

Previous
From: "Thapliyal, Deepak"
Date:
Subject: Parse error help needed...
Next
From: Doug McNaught
Date:
Subject: Re: Parse error help needed...