Received: from nest.bistbn.com (postgres@nest.bistbn.com [209.88.174.52]) by hub.org (8.9.1/8.9.1) with ESMTP id GAA01106 for ; Mon, 14 Dec 1998 06:29:15 -0500 (EST) (envelope-from postgres@nest.bistbn.com) Received: from localhost (postgres@localhost) by nest.bistbn.com (8.9.1/8.9.1) with SMTP id NAA05333; Mon, 14 Dec 1998 13:28:56 +0200 (IST) Date: Mon, 14 Dec 1998 13:28:55 +0200 (IST) From: Postgres DBA To: Remigiusz Sokolowski cc: Frank Morton , pgsql-sql@postgreSQL.org Subject: Re: [SQL] Newbie questions In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII About LIMIT: it is implemented as feature add-on to 6.4 release and could be downloaded from patch directory on Postgres FTP site. Al. On Mon, 14 Dec 1998, Remigiusz Sokolowski wrote: > > Question #1 > > > > If a select might match MANY rows, how can I limit it to say 50? > > > > I thought you could do: > > > > select * from table limit 50; > > look at description of cursor in man - there are also examples > begin work; > declare cursor bookmark for > your select statement; > fetch 50 in bookmark; > close bookmark; > commit;B > > > > > Question #2 > > > > In doing a select, is there a way to ignore if the case of the key? > > > > For example, if I have a table called animals with an id column and > > it might contain "dog" or "DOG" or "Dog" and I want to match all > > of them, how do I do it, with or without the "like" operator? > > > > I'd like to say: > > > > select * from animals where id='dogs' ignore case; > > look at operators in docs > ~~ - LIKE operator > ~* - match(regex), case insensitive operator > I have no idea which is better > Rem > p.s. I could make some mistakes in this examples - check in amnual or docs > -------------------------------------------------------------------------------- > Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl > -------------------------------------------------------------------------------- > > > >