| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | Graham Vickrage <graham(at)digitalplanit(dot)com> |
| Cc: | Postgres SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: quotes nightmare! |
| Date: | 2002-02-22 16:28:56 |
| Message-ID: | 20020222162856.GC959@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, Feb 22, 2002 at 01:18:51PM +0000, Graham Vickrage wrote:
> BEGIN
> EXECUTE ''
> CREATE FUNCTION _test'' || $1 || '' () RETURNS int AS ''
When you enter these '' you are ending the EXECUTE block. If you don't
want to end thit EXECUTE block, then you have to espace each of these
quotes.
> Could anyone tell me which bit is causing the problem as I am now completely
> lost, the error message mentions is near LANGUAGE.
You should look at:
http://www.postgresql.org/idocs/index.php?plpgsql-porting.html#PLPGSQL-QUOTING-TABLE
http://www.postgresql.org/idocs/index.php?plpgsql-porting.html#PLPGSQL-PORTING-NASTYQUOTE
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Advisor: The guy who told you how to screw up
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-02-22 16:51:55 | Re: Date Problem |
| Previous Message | Stephan Szabo | 2002-02-22 16:13:02 | Re: How does Index Scan get used |