Re: substring syntax with regexp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: substring syntax with regexp
Date: 2004-06-30 15:47:37
Message-ID: 9489.1088610457@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

joseph speigle <joe(dot)speigle(at)jklh(dot)us> writes:
> CREATE or replace FUNCTION hostname() RETURNS setof logpgsql.stats_type as
> '
> declare
> ...
> newuri = substr(tempuri from 'http://[^/]*/.*');

You forgot about doubling quotes within a function body :-(

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2004-06-30 15:52:21 backups
Previous Message laurent.marzullo 2004-06-30 15:18:06 Transaction XID