Sender: leon@ningaui.quoll.inf.net.au
Message-ID: <37166813.158A5@quoll.com>
Date: Fri, 16 Apr 1999 06:28:36 +0800
From: Leon Harris <leon@quoll.com>
MIME-Version: 1.0
To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Getting started with visual query builder in pgaccess
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi to all.
Please forgive my newness to postgres and pgaccess. 
I am trying to get started using pgaccess. I can't seem to find much
doccumentation on the visual query builder, as well as other things.

Could someone please tell me what I am doing wrong here?

I start with a table called people

people
----------------|----------
fldIdNumber	|
fldFirstName 	|
fldLastName     |


I add this table to the visual designer, and then I drag and drop the
fldIdNumber into the field row. The designer inserts the table name, and
then I change criteria to  > 1 - meaning I want to return all First and
last names whose Idnumber is greater than 1. 

All that happens is I get a syntax error. The sql I wanted was something
like
select * from tblpeople where ( fldIdNumber > 1).

Instead, I get 
select t0.fldIdNumber from tblpeople where (t0.fldIdNumber > 1)

I have also tried this without uppercase. Is there any sort of decent
tutorial for pgaccess? 

what is happenning here? 

TIA
Leon Harris