Problem with odbc.sql

On Friday 04 Apr 2003 11:21 am, alain.bruneau@acoss.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