Re: indexes on varchar fields - Mailing list pgsql-general

From Tom Lane
Subject Re: indexes on varchar fields
Date
Msg-id 19751.1039711266@sss.pgh.pa.us
Whole thread Raw
In response to Re: indexes on varchar fields  (Peter Nixon <listuser@peternixon.net>)
List pgsql-general
Peter Nixon <listuser@peternixon.net> writes:
> radius=# create function testperltest3 (text) returns text as '
> radius'#         my $datetime = $_[0];
> radius'#         # Remove . from the start of time fields (routers that have
> lost ntp timesync)
> radius'#         $datetime =~ s/^\.*//;
> radius'#         return $datetime;
> radius'# ' language 'plperl';
> CREATE FUNCTION

You need another backslash --- the string-literal parser is eating that
one, so Perl sees s/^.*//.

            regards, tom lane

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Re: installing with readline
Next
From: Tom Lane
Date:
Subject: Re: installing with readline