Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15315; Fri, 28 Feb 92 13:59:11 -0800
Date: Fri, 28 Feb 92 13:59:11 -0800
Message-Id: <9202282159.AA15315@postgres.Berkeley.EDU>
From: orestes appel <oappel@copper.ucs.indiana.edu>
Subject: PQexec in complex retrieve operations
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Cc: mer@postgres.Berkeley.EDU, oappel@copper.ucs.indiana.edu

When running a C program and sending Postquel commands to the backend,
we are having trouble when these expressions are not the simplest ones.
For instance:

 PQexec ("retrieve portal eportal (EMP.all) where EMP.age=29");
 PQexec ("fetch all in eportal");

doesn't work when compiling. We've got the following message:

"try.c", line 26: newline in string or char constant
"try.c", line 29: syntax error at or near variable name "PQexec"

However, when using:

 PQexec ("retrieve portal eportal (EMP.all)");
 PWexec ("fetch all in eportal");

it works perfectly.

It looks like it doesn't understand what's going on after the right
parenthesis in (EMP.all).
Should we use a different syntax? Are we using the wrong command?
Is it behaving the way it is expected?

We appreciate any pointers about this.


Thanks in advance.

	Orestes Appel