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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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.


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-2017 The PostgreSQL Global Development Group