Skip site navigation (1) Skip section navigation (2)

Re: between

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: merlyn(at)stonehenge(dot)com (Randal L(dot) Schwartz)
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: between
Date: 2003-12-26 23:35:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
El Vie 26 Dic 2003 20:10, Randal L. Schwartz escribió:
> >>>>> "Martin" == Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
> Martin> A link to the URL above in the SELECT page?
> Uh, do you also want a link to "installing PostgreSQL" there too?
> After all, you have to install Pg before you can use the SELECT
> operator.

Please, don't get me wrong, I have read great part on the PG manuals already, 
and have mad lots of Solaris instalation in times of the early PG 7.0, when 
there was not much experience on this OS, and have been trying to make a 64 
bit build on Linux/SPARC.

Do you think I would have been able to do this without reading "installing 
PostgreSQL"? :-)

> It's not any more related to SELECT than it is anything else.  It's a
> part of an expression.  Expressions are used many places and described
> one place.  That's the nature of documentation.
> Maybe I'm sounding grouchy, but at some point, you do the common sense
> thing.

I personaly find this incomplete:

==================>CUT FROM THE SELECT MANUAL<===========================
 WHERE Clause

The optional WHERE condition has the general form:

WHERE boolean_expr

boolean_expr can consist of any expression which evaluates to a Boolean value. 
In many cases, this expression will be:

     expr cond_op expr


     log_op expr

where cond_op can be one of: =, <, <=, >, >= or <>, a conditional operator 
like ALL, ANY, IN, LIKE, or a locally defined operator, and log_op can be one 
of: AND, OR, NOT. SELECT will ignore all rows for which the WHERE condition 
does not return TRUE.
==================>CUT FROM THE SELECT MANUAL<===========================

Now in this last paragraph there are some comparision operators. How awful 
could it be to just add the word "BETWEEN" there? I know the BETWEEN sintax, 
but as I didn't see it there I thought, wrongly, that it wasn't supported.

Maybe it's that I have the bad habit of just reading the "SQL Commands" while 
I work, and having a very volatile memory. :-)

select 'mmarques' || '@' || '' AS email;
Martín Marqués                  |        mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral

In response to

  • Re: between at 2003-12-26 23:10:17 from Randal L. Schwartz


pgsql-general by date

Next:From: Tom LaneDate: 2003-12-26 23:44:58
Subject: Re: between
Previous:From: Tom LaneDate: 2003-12-26 23:22:11
Subject: Re: update i386 spinlock for hyperthreading

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group