X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 67D51475F16
	for <pgsql-sql@postgresql.org>; Wed, 23 Apr 2003 09:56:43 -0400 (EDT)
Received: from web20808.mail.yahoo.com (web20808.mail.yahoo.com
	[216.136.226.197])
	by postgresql.org (Postfix) with SMTP id 4B343475ADE
	for <pgsql-sql@postgresql.org>; Wed, 23 Apr 2003 09:56:41 -0400 (EDT)
Message-ID: <20030423135645.97679.qmail@web20808.mail.yahoo.com>
Received: from [208.13.35.65] by web20808.mail.yahoo.com via HTTP;
	Wed, 23 Apr 2003 06:56:45 PDT
Date: Wed, 23 Apr 2003 06:56:45 -0700 (PDT)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: how to put an special code in a string
To: jack <datactrl@tpg.com.au>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <3EA637B9.5060404@klaster.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Spam-Status: No, hits=-16.3 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/324
X-Sequence-Number: 13025

--- Tomasz Myrta <jasiek@klaster.net> wrote:
> Uz.ytkownik jack napisa?:
> > Hi all,
> > 
> > With pg/Sql, how do I put an special code in a
> string? Such as
> > 
> > ''abc'' || <tab>||''xxx''||<cr/lf>
> > 
> > How do I specify a tab or cr/lf code? Thank you
> C style should work. Try
> <tab> -> \t
> <cr/lf> -> \r\n ?

A generalized solution is to use the chr() function,
which can represent any ascii character, given the
decimal value as an argument.
So, <tab> is chr(9); <cr/lf> is chr(13) || chr(10)

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com