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