--- On Mon, 10/20/08, pere roca <peroc79@xxxxxxxxx> wrote: > From: pere roca <peroc79@xxxxxxxxx> > Subject: re moving a portion of text > To: pgsql-general@xxxxxxxxxxxxxx > Date: Monday, October 20, 2008, 11:21 AM > hi, > I have a column with full of data like ATB-OO NCK-TT > .... how can I > easily remove the "-" ? it seems that the > "-" is allways the fourth letter. > > thanks, > Pere > -- > View this message in context: > http://www.nabble.com/removing-a-portion-of-text-tp20067248p20067248.html > Sent from the PostgreSQL - general mailing list archive at > Nabble.com. > > with fixed length select substring(tex1,1,3) || substring(tex1,5) from t1 with variable length select substring(tex1,1,strpos(tex1,'-'::varchar)-1) || substring(tex1,strpos(tex1,'-'::varchar)+1) from t1 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
