Re: Problem with odbc.sql - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problem with odbc.sql
Date
Msg-id 200304041232.34270.dev@archonet.com
Whole thread Raw
In response to Problem with odbc.sql  (alain.bruneau@acoss.fr)
List pgsql-general
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


pgsql-general by date:

Previous
From: Thierry Missimilly
Date:
Subject: Successful Customer references
Next
From: Andrew Sullivan
Date:
Subject: Re: feature request - adding columns with default value