Postgres Pro
Downloads
Home   >   mailing lists

Re: references/tutorial/tricks on dynamic generation of sql (& plpgsql functions) editing/coding - Mailing list pgsql-general

From John DeSoi
Subject Re: references/tutorial/tricks on dynamic generation of sql (& plpgsql functions) editing/coding
Date
Msg-id 856BEC43-39D7-468B-A78B-5B6B822A81E0@pgedit.com
Whole thread Raw
In response to references/tutorial/tricks on dynamic generation of sql (& plpgsql functions) editing/coding  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: references/tutorial/tricks on dynamic generation of
List pgsql-general
Tree view 
On Sep 11, 2006, at 8:34 AM, Ivan Sergio Borgonovo wrote:

> Since the code inside the function is getting a bit longer than
> what I was used I'm getting crazy about double quotes, syntax
> highlight and such.
> I'm using pg 7.4 so $$ trick shouldn't work.

If you can't update to 8.0 or later, you might want to look at
pgEdit. It can correctly syntax highlight pl/pgsql functions with
nested quotes.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

pgsql-general by date:

Previous
From: "Purusothaman A"
Date:
Subject: Re: [ADMIN] Problem with lo_export() and lo_import() from remote machine.
Next
From: Michael Fuhr
Date:
Subject: Re: Certificate, login & php question ? krb / sso