Skip site navigation (1) Skip section navigation (2)

Re: pgsql question

From: Steven Klassen <sklassen(at)commandprompt(dot)com>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgsql question
Date: 2004-12-29 22:43:39
Message-ID: 20041229224339.GA9863@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
# I need to to change an ip addres in a plpgsql function from
# aaa.bbb.ccc.ddd to an sring containing "aaa bbb ccc ddd upload".

sklassen=> select replace('216.237.145.1'::text, '.', ' ') || ' upload';
       ?column?       
----------------------
 216 237 145 1 upload
(1 row)

-- 
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

In response to

pgsql-general by date

Next:From: Matthew TerenzioDate: 2004-12-29 22:49:37
Subject: Fwd: Advice on moving rows to history
Previous:From: Scott MarloweDate: 2004-12-29 22:36:48
Subject: Re: pg_dump and pgpool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group