X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 0C207D1B44A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 14 Jan 2004 22:48:25 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 44249-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 14 Jan 2004 18:47:55 -0400 (AST)
Received: from web12107.mail.yahoo.com (web12107.mail.yahoo.com
	[216.136.172.27])
	by svr1.postgresql.org (Postfix) with SMTP id 6B57ED1D54A
	for <pgsql-sql@postgresql.org>; Wed, 14 Jan 2004 18:47:52 -0400 (AST)
Message-ID: <20040114224753.1013.qmail@web12107.mail.yahoo.com>
Received: from [69.72.27.2] by web12107.mail.yahoo.com via HTTP;
	Wed, 14 Jan 2004 14:47:53 PST
Date: Wed, 14 Jan 2004 14:47:53 -0800 (PST)
From: A E <cooljoint@yahoo.com>
Subject: REPOST[GENERAL] Quoting for a Select Into - Please Help
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1564054890-1074120473=:669"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.6 tagged_above=0.0 required=5.0 tests=HTML_20_30,
	HTML_TAG_EXISTS_TBODY
X-Spam-Level: *
X-Archive-Number: 200401/124
X-Sequence-Number: 16517

--0-1564054890-1074120473=:669
Content-Type: text/plain; charset=us-ascii

Hi,
 
Could someone help me with quoting this right?
 
select into aliasvalue ''|| trim(arrayval[i]) ||''  from ''|| trim(realname) ||'' where ''|| trim(searchfield) ||'' like ''''%''|| trim(searchvalue) ||''%''''; 
 
The parser does not seem to want to put the value of the variables into the statement.
 
Alex


--0-1564054890-1074120473=:669
Content-Type: text/html; charset=us-ascii

<DIV>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 ?>
<TBODY>
<TR>
<TD>
<DIV>Hi,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Could someone help me with quoting this right?</DIV>
<DIV>&nbsp;</DIV>
<DIV>select into aliasvalue ''|| trim(arrayval[i]) ||''&nbsp; from ''|| trim(realname) ||'' where ''|| trim(searchfield) ||'' like ''''%''|| trim(searchvalue) ||''%''''; </DIV>
<DIV>&nbsp;</DIV>
<DIV>The parser does not seem to want to put the value of the variables into the statement.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Alex</DIV></TD></TR></TBODY></TABLE></DIV>
--0-1564054890-1074120473=:669--