Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199312210108.RAA03005@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Mon, 20 Dec 1993 17:08:23 -0800
From: "Guy R. Thomas" <gthomas@native-ed.bc.ca>
Message-Id: <199312210108.RAA14643@ raven.native-ed.bc.ca >
To: postgres@postgres.Berkeley.EDU
Subject: What is an unterminated char/string constant?
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Mon, 20 Dec 93 17:08:34 -0800
Resent-XMts: smtp

Hi;

I am using perl ( not pg-perl )to interact with postgres.  I assign a  
value to a perl varrialble like so:

   ($address_2, $city, $province, $country,
   $postal_code,$liais_numb) = split(/\|/, $_);

Where $_ comes from a text file. Thus $liais_numb is a text string in  
perls eyes.  In the class liaisons, liais_numb is an int2 field. Thus  
the query that I try to send to postgres is:

   system ("monitor commcontent -N -c \"retrieve ( l.all ) 

   from l in liaisons where l.liais_numb = \\\"$liais_numb\\\" ::int2
   \" > /tmp/liaison ");

the error porduced is:


WARN:Dec 20 17:02:22:*** scanner error: Unterminated char/string  
constant

Is this a quirk in perl or postgres?  How do I terminate perl  
strings?  Mystery galore.

---
Guy R. Thomas                           Native Education Centre
Library Coordinator                     285 East Fifth Avenue
gthomas@native-ed.bc.ca                 Vancouver B. C.
V:(604) 873-3761 --- F:(604) 873-9152   V5T 1H2