Re: between - Mailing list pgsql-general

From Mike Nolan
Subject Re: between
Date
Msg-id 200312261602.hBQG2ig9028814@gw.tssi.com
Whole thread Raw
In response to between  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Re: between  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-general
> Is there any chance on supporting BETWEEN in the WHERE conditions of a SELECT
> clause?

You mean like this?

Welcome to psql 7.4.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
      \h for help with SQL commands
      \? for help on internal slash commands
      \g or terminate with semicolon to execute query
      \q to quit

Timing is on.
uscf=> select count(*) from memmast
uscf-> where memid between '10000000' and '19999999';
count
--------
514070
(1 row)

That's been in PostgreSQL for a long time.
--
Mike Nolan


pgsql-general by date:

Previous
From: Ken Harris
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: Jan Wieck
Date:
Subject: Re: Is my MySQL Gaining ?