Re: PGAccess/pgplsql Blues - Mailing list pgsql-sql

From Josh Berkus
Subject Re: PGAccess/pgplsql Blues
Date
Msg-id web-66746@davinci.ethosmedia.com
Whole thread Raw
In response to Re: PGAccess/pgplsql Blues  (Roberto Mello <rmello@cc.usu.edu>)
Responses Re: PGAccess/pgplsql Blues
List pgsql-sql
Roberto,

>  IIRC, pgaccess does quote-escaping for you, so if you try to write
> "standard" PL/pgSQL (escaping single quotes), it'll barf this error.
> 
>  Just something to check. 

Thanks.  This doesn't seem to be the case; it seems to be a translation
problem:

1. Test fn_save_order: it's working.
2. Open fn_save_order in PGAccess.
3. Add '--test comment' on its own line.
4. Save fn_save_order.
5. test it: "Parse Error at or near "" "

Unfortunately, I can't afford to pay Constatin for debugging, so that's
where things stand ...

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: SQL Date Challenge
Next
From: Manuel Sugawara
Date:
Subject: Re: SQL Date Challenge