Re: Updated .vim file - Mailing list pgsql-general

From David Fetter
Subject Re: Updated .vim file
Date
Msg-id 20071031140043.GD10414@fetter.org
Whole thread Raw
In response to Updated .vim file  (Decibel! <decibel@decibel.org>)
List pgsql-general
On Tue, Oct 30, 2007 at 01:58:29PM -0500, Decibel! wrote:
> Does anyone have a .vim file that takes dollar quoting into account?
> I've tried the one mentioned at
> http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
> it doesn't appear to understand dollar quotes.

The magic appears to be something like:

:syn match pgsqlMyMatch /\$\$.\{.}\$\$/

The real regex would look a lot hairier for arbitrary legal dollar
quoting constructs, but if you standardize on something like what's
below, it should be easier.

Cheers,
David.

CREATE [OR REPLACE] FUNCTION foo(
    input,
    params,
    here,
    [OUT put_params_here,
    ...]
)
RETURNS [SETOF] SOMETYPE
[IMMUTABLE]
[STRICT]
LANGUAGE plbar
AS $[STUFF]$
...
$[STUFF]$;
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Replacing RDBMS
Next
From: mgould
Date:
Subject: Securing stored procedures and triggers