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

REPOST[GENERAL] Quoting for a Select Into - Please Help

From: A E <cooljoint(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: REPOST[GENERAL] Quoting for a Select Into - Please Help
Date: 2004-01-14 22:47:53
Message-ID: 20040114224753.1013.qmail@web12107.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

Responses

pgsql-sql by date

Next:From: Jeffrey TennyDate: 2004-01-15 00:51:49
Subject: Atomic query and update of sequence generators
Previous:From: Luis C. Ferreira (aka lcf)Date: 2004-01-14 21:03:49
Subject: Re: Transpose rows to columns

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