Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id MAA70965 for ; Mon, 30 Aug 1999 12:48:30 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id JAA11886; Mon, 30 Aug 1999 09:47:54 -0700 From: "tjk@tksoft.com" Message-Id: <199908301647.JAA11886@uno.tksoft.com> Subject: Re: [SQL] problem with select To: holm@freibergnet.de Date: Mon, 30 Aug 1999 09:47:54 -0700 (PDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <19990830140452.B21897@pegasus.freibergnet.de> from "Holm Tiffe" at Aug 30, 99 02:04:52 pm Content-Type: text Holm, Can you clarify the problem a bit? > So far so good, but I have the problem that I have the value 'abc' > only one times ! Do you mean you only get one row as a result? You might do better with using "group by" instead of distinct, if you only want a distinct code. I.e. select code,category from products where code ~* 'abc' or category ~* 'abc' or manufacturer ~* 'abc' or description ~* 'abc' or comment ~* 'abc' group by code; Troy > > Hi all, > > I have an problem and I can't find a solution. > > I have a products database like this: > > code varchar, > category varchar, > title varchar, > manufacturer varchar, > description varchar, > desc_de varchar, > comment varchar, > price float, > ... > > What I try to find is a solution for a search in this table like this: > > select distinct code,category from products where code ~* 'abc' or > category ~* 'abc' or manufacturer ~* 'abc' or description ~* 'abc' > or comment ~* 'abc' order by code; > > So far so good, but I have the problem that I have the value 'abc' > only one times ! > > This is in conjunction with minivend, an internet shopping mall, > the query is generated as follows: > > .... > > > > > VALUE="select code,category from products where comment ~* ?"> > ^^^ >
> >
> .... > > The question mark get's replaced by the contents of the HTML input field, > and I have no chance to create a temporary table here (security issue). > > I must create a view or a rule or something to get a query like this: > > VALUE="select foobar from myview where comment ~* ?"> > > How can this be done ? > > > Thanks in Advance, > Holm > -- > FreibergNet Systemhaus GbR Holm Tiffe * Administration, Development > Systemhaus für Daten- und Netzwerktechnik phone +49 3731 781279 > Unternehmensgruppe Liebscher & Partner fax +49 3731 781377 > D-09599 Freiberg * Am St. Niclas Schacht 13 http://www.freibergnet.de/ > > > ************ > >