Received: from mail3.lig.bellsouth.net (mail3.lig.bellsouth.net
	[207.203.120.42])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3O1Nm355775;
	Mon, 23 Apr 2001 21:23:49 -0400 (EDT) (envelope-from rgp@systame.com)
Received: from [216.77.205.159] (host-216-77-205-159.psl.bellsouth.net
	[216.77.205.159])
	by mail3.lig.bellsouth.net (3.3.5alt/0.75.2) with ESMTP id VAA12988;
	Mon, 23 Apr 2001 21:23:44 -0400 (EDT)
User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022
Date: Mon, 23 Apr 2001 21:20:35 -0400
Subject: Var substitution in SELECT statements
From: Randall Perry <rgp@systame.com>
To: <pgsql-interfaces@postgresql.org>, <pgsql-general@postgresql.org>
Message-ID: <B70A4D23.A28D%rgp@systame.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Archive-Number: 200104/991
X-Sequence-Number: 8205

This works:
$res  = $conn->exec("select cust, contact, user_name, email from $t where
user_name = a1a");

This doesn't:
$c = "a1a";
$res  = $conn->exec("select cust, contact, user_name, email from $t where
user_name = $c");

and returns the error:
    Attribute 'a1a' not found
    
    
How do you do var substitution with the Pg module in Perl?

-- 
Randy Perry
sysTame
Mac Consulting/Sales