A. Kretschmer wrote:
Not sure, but host is a reserved word, see:
http://www.postgresql.org/docs/8.1/interactive/sql-keywords-appendix.html
That list says that HOST is reserved in SQL:1999, but not in PostgreSQL.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
Please post is possible the code (DDL and function).
Otherwise it'd be much more difficult.
And if you change the names, please check whether the error is still there.
--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand
On Thursday 08 January 2009 09:15:05 Mayuresh Nirhali wrote:
> No. t
No. there are no name clashes.
I actually changed the names in posted text a bit. The arguments,
declared variables and column names, all have their unique prefixes.
Thanks
Mayuresh
Reg Me Please wrote:
IS there any name clash with a function argument?
--
Fahrbahn ist ein graues Band
weisse
In response to Mayuresh Nirhali :
> Hello,
>
> I am working with 8.1.4 pgsql as my database backend. I have a function
> written in plpgsql language, that queries a particular table as below,
>
> select host from table_host where ip_address = ip_array[i] and port =
> port_array[i];
>
> The que
IS there any name clash with a function argument?
--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand
On Thursday 08 January 2009 08:30:07 Mayuresh Nirhali wrote:
> Hello,
>
> I am working with 8.1.4 pgsql as my database backend. I have a function
> written in plpgsql language, that quer
