El Vie 26 Dic 2003 13:02, Mike Nolan escribió: > > 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.
Damn, didn't find it in the docs, and just supposed it wasn't there. Well, shouldn't there be something writen especially in the SELECT manual? http://www.postgresql.org/docs/current/interactive/sql-select.html Sorry for not checking it out before. :-( -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; ----------------------------------------------------------------- Martín Marqués | [EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral ----------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
