Message-ID: <42D61ED7.1040707@archonet.com>
Date: Thu, 14 Jul 2005 09:14:15 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317)
MIME-Version: 1.0
To: Richard Hayward <richard@tortoise.demon.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: function parameters : bug?
References: <ugu1d19614tuteki2jgm0496d58kcggdhn@4ax.com>
In-Reply-To: <ugu1d19614tuteki2jgm0496d58kcggdhn@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Richard Hayward wrote:
> pg 8.0.3
> This behaviour seems odd to me:
> 
> CREATE TABLE mytable (
>   inta INTEGER
> );
> 
> CREATE OR REPLACE FUNCTION myfunction (inta integer) RETURNS integer 
> AS 
> $body$ 
> begin
>   insert into mytable(inta) values (inta);

> ERROR:  syntax error at or near "$1" at character 22
> QUERY:  insert into myTable( $1 ) values ( $2 )
> CONTEXT:  PL/pgSQL function "myfunction" line 2 at SQL statement
> 
> The problem is with the line in my myfunction:
>   insert into mytable(inta) values (inta);
> 
> The server doesn't like the field name being the same as the name of
> the function parameter. I don't see why, as I can see no opportunity
> for ambiguity.

So what would this do?
   SELECT inta+1 FROM mytable

Agreed, it's tricky, but without some variable marker (e.g. $my_param) 
or removing inline SQL from the language, I'm not sure there's much to do.

--
   Richard Huxton
   Archonet Ltd