Re: Query Help

Postgres supports regular expressions

Check out section 4.5.2 POSIX reglar expressions

Darren

Darren Ferguson
Software Engineer
Openband

On Mon, 17 Dec 2001, Joe Koenig wrote:

> Thanks for the responses - I was able to patch something together from
> the responses. On to the next thing - I want to do a search based on a
> reg ex. Does PostgreSQL have something like MySQL's "RLIKE"? I want to
> pull all records in a category that start with a number 0-9. The best
> way I saw was to do a UNION with all the numbers, but I figured there
> was a better way. Thanks,
>
> Joe
>
> Chris Albertson wrote:
> >
> > Try this:
> >
> >   1) Remove DISTINCT ON(item.description)
> >   2) Add "GROUP BY item.description"
> >   3) Add (after SELECT) "count(pack_num),"
> >
> > --- Joe Koenig <joe@jwebmedia.com> wrote:
> > > I have an existing query to pull some product info from my db - there
> > > is
> > > a field, item.pack_num, that tells whether the item is new (1) or
> > > used
> > > (2). When I display the listing to the web users, I want to be able
> > > to
> > > tell them if a used item is available for each item in the list.
> > > However, I want this to all be done with 1 query - so what I'm
> > > wondering
> > > is, is there a way to modify my exising query (below) to have it give
> > > the the item with the pack_num of 2, if there are new and used items
> > > in
> > > the db. The DISTINCT ON(item.description) is there because if there
> > > is a
> > > new and used item, the item is listed in the db twice, once for each
> > > pack_num (I know, bad layout - not my idea...). I don't want the
> > > query
> > <SNIP>
> >
> > =====
> > Chris Albertson
> >   Home:   310-376-1029  chrisalbertson90278@yahoo.com
> >   Cell:   310-990-7550
> >   Office: 310-336-5189  Christopher.J.Albertson@aero.org
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for all of
> > your unique holiday gifts! Buy at http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>