Postgres Pro
Downloads
Home   >   mailing lists

Re: substring syntax with regexp - Mailing list pgsql-general

From Tom Lane
Subject Re: substring syntax with regexp
Date
Msg-id 9489.1088610457@sss.pgh.pa.us
Whole thread Raw
In response to substring syntax with regexp  (joseph speigle <joe.speigle@jklh.us>)
List pgsql-general
Tree view 
joseph speigle <joe.speigle@jklh.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DML Restriction unless through a function
Next
From: Richard Welty
Date:
Subject: Re: backups