"Mike G." <[EMAIL PROTECTED]> writes:
> Maybe it is because 'name' is a sql 92/99 non-reserved / key word?
No, it's because of careless choice of plpgsql variable names.
>> declare
>> uri alias for $3;
>> ...
>> insert into uri (articleid,uri,uritype) values (article_id,uri,urit_id);
On Mon, Jan 17, 2005 at 05:46:20AM +0100, LENGYEL Zoltan wrote:
> uri alias for $3;
...
> insert into uri (articleid,uri,uritype) values (article_id,uri,urit_id);
PostgreSQL 8.0 will give more context for the error, making it
easier to spot the problem:
ERROR: syntax error at or near "$1" at
Maybe it is because 'name' is a sql 92/99 non-reserved / key word?
On Mon, Jan 17, 2005 at 05:46:20AM +0100, LENGYEL Zoltan wrote:
> Hi,
>
> I have a pgpsql function:
>
> create or replace function new_uri(varchar,varchar,varchar) returns
> integer as '
> declare
> src alias for $1;
> tit a
