[Babase] Query error?
Karl O. Pinc
kop at meme.com
Thu Aug 24 22:12:08 EDT 2006
On 08/24/2006 09:02:48 PM, Catherine Markham wrote:
> Hi all,
>
> I have a question about the query below. We were working in the new
> system this afternoon and Laurence wanted to select all the rows in
> repstats where a female was pregnant during 1999-2005. What I tried
> was:
>
> create table play4 as
> select * from repstats where state = 'P' and date > '1999-12-31' and
> date < '2006-01-01' order by date;
>
> This did give us an output which, as far as we could tell, seemed
> correct. However, the system displayed a message saying there was a
> query error.
>
> Karl and Leah, do you see the mistake?
What was the error message? That's the first question.
Unless your search path is set to put your personal schema
first then you're trying to create a table in the babase
schema and you don't have permissions to do so. Qualify
the table name with the schema. (amarkham.play4)
Can you have a table name with a digit in it?
The select statement works, so it must be in the create table
part if it's a syntax error.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list