Received: from frithjof.reiner (qmailr@c94.dialin.tuwien.ac.at [192.35.243.104]) by hub.org (8.9.3/8.9.3) with SMTP id QAA32005 for ; Wed, 6 Oct 1999 16:26:07 -0400 (EDT) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 9427 invoked by uid 500); 5 Oct 1999 16:23:34 -0000 From: "Albert REINER" Date: Tue, 5 Oct 1999 18:23:33 +0200 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Reasonable Message-ID: <19991005182333.A4844@frithjof> Mail-Followup-To: pgsql-sql@postgreSQL.org References: <019801bf0f46$e1f01c00$40ee2fd8@venux.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.6i In-Reply-To: <019801bf0f46$e1f01c00$40ee2fd8@venux.net>; from Mitch Vincent on Tue, Oct 05, 1999 at 11:32:50AM -0400 On Tue, Oct 05, 1999 at 11:32:50AM -0400, Mitch Vincent wrote: ... > The query that's giving me fits : > > > > CREATE TABLE "user_applicant_search" ( > "app_id" int4, > "created" datetime, > "createdcond" varying(2), > "status" character varying(1) default 'Active', > "statuscond" character varying(1) default '=', > "firstname" character varying(25), > "firstnamecond" character varying(2) default '=', > "lastname" character varying(25), > "lastnamecond" character varying(2) default '=', > "address1" character varying(30), > "address1cond" character varying(2) default '=', > "address2" character varying(30), > "city" character varying(20), > "citycond" character varying(8) default 'starts', > "state" character varying(10), > "statecond" character varying(2) default '=', > "email" character varying(50), > "emailcond character varying(8) default 'starts', ... ^^^^^^ Don't you need a closing "? Albert. -- --------------------------------------------------------------------------- Post an / Mail to / Skribu al: Albert Reiner ---------------------------------------------------------------------------