Re: Problem with odbc.sql

On Friday 04 Apr 2003 11:21 am, alain(dot)bruneau(at)acoss(dot)fr wrote:
> Hi.
>
> I'm trying to install psqlodbc-7.2.5 driver.
>
> I have some trouble with odbc.sql shell script.
>
> test=# CREATE OR REPLACE FUNCTION "char"(integer) RETURNS text AS '
> test'# SELECT chr($1);
> test'# ' LANGUAGE SQL;
> ERROR: parser: parse error at or near "OR"

I think CREATE OR REPLACE is a recent thing.

> test=# CREATE FUNCTION "char"(integer) RETURNS text AS '
> test'# SELECT chr($1);
> test'# ' LANGUAGE SQL;
> ERROR: parser: parse error at or near "sql"

Do you not need to quote the "SQL"?

> Perhaps due to my Postgresql version : postgresql-7.1.2.0

--
Richard Huxton