Re: String manipulation in plpgsql

From: "Rod Kreisler" <rod(at)23net(dot)net>
To: "Joe Conway" <mail(at)joeconway(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: String manipulation in plpgsql
Date: 2003-03-09 00:34:25
Message-ID: JNEGKNDJGBKLBDGPOPFOOEPODKAA.rod@23net.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Joe Conway
> Sent: Saturday, March 08, 2003 7:24 PM
> To: Rod Kreisler
> Cc: pgsql-novice(at)postgresql(dot)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
>
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-03-09 00:39:01 Re: Stored procedure - change columns in a table that is
Previous Message Joe Conway 2003-03-09 00:24:06 Re: String manipulation in plpgsql