Re: String manipulation in plpgsql - Mailing list pgsql-novice

From Rod Kreisler
Subject Re: String manipulation in plpgsql
Date
Msg-id JNEGKNDJGBKLBDGPOPFOOEPODKAA.rod@23net.net
Whole thread Raw
In response to Re: String manipulation in plpgsql  (Joe Conway <mail@joeconway.com>)
List pgsql-novice
OK, that's it, I'm not working for 32 hours straight ever again...

I didn't even think about sql functions.

Thanks

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Joe Conway
> Sent: Saturday, March 08, 2003 7:24 PM
> To: Rod Kreisler
> Cc: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] String manipulation in plpgsql
>
>
> Rod Kreisler wrote:
> > Is there a way to do string manipulation in plpgsql, or should
> I just use
> > plperl?  It's just been SO long since I've used perl, trying to
> avoid it....
> >
>
> You can use any of the existing string functions, string concatenation,
> etc. See:
>
> http://developer.postgresql.org/docs/postgres/functions-string.html
> and
> http://developer.postgresql.org/docs/postgres/plpgsql-statements.html
>
> as a start. Anything complex is probably a lot easier in plperl (or
> pltcl or plpython) though.
>
> HTH,
>
> Joe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>

pgsql-novice by date:

Previous
From: Joe Conway
Date:
Subject: Re: String manipulation in plpgsql
Next
From: Tom Lane
Date:
Subject: Re: Stored procedure - change columns in a table that is