pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Bob Smither <smither@C-C-I.Com>
To: Michael Olivier <molivier@yahoo.com>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] abs value, power, sqrt
Date: Fri, 20 Nov 1998 18:44:48 -0600 (EST)
Message-ID: <Pine.LNX.3.96.981120181104.23513A-200000@cci.c-c-i.com> (raw )
In-Reply-To: <19981120055303.6281.rocketmail@send105.yahoomail.com >
On Thu, 19 Nov 1998, Michael Olivier wrote:
:Hi folks,
:
:I previously posted this to pgsql-novice but haven't gotten an answer,
:so I thought I'd try here.
:
:I need a way to get abs value of a floating point number and (possibly
:separate function for) abs value of an integer in a select statement.
:Is there a function to do this? If not, how can I write a function to
:do it?
:
:Also how do I do squares and square roots? I saw some \|/ type notation
:for square root in an SQL book, but I didn't get postgres to take that.
On my RH installation I found:
file:/usr/doc/postgresql-6.3.2/user/c05.htm
which I have attached. It documents the operators and functions
available. Examples of your specific operators are:
absolute value: @-5
square root : |/ 25
Square would just be x * x or use the exponentiation operator:
2.0 ^ 3.0
As an example, here is a snippet from a perl cgi script that finds all the
zip codes within a specified radius of a target location. The target
location is specified by $lat and $lon (in degrees), the radius by
$Radius (in miles).
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
#! /usr/bin/perl -w
# file: zips.by.location.m4
snip ...
# radius is in miles ...
$Radius = $input{'radius'};
# convert radius to degrees, circumference is pi * d
$Radius = $Radius * 360.0 / (7900.0 * atan2(1,1) * 4.0);
$RadiusSquared = $Radius * $Radius;
snip ...
# call psql to find the zip codes ...
$temp = qx{ psql -d lrcf -c "
select
city, state, zip5,
population, latitude, longitude
from
zips
where
( ( ((latitude - $lat) ^ 2.0) +
((longitude - $lon) ^ 2.0) )
< $RadiusSquared );" };
# print results to html page
print "<pre>$temp</pre>";
snip ...
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Hope this helps,
======================================================================
Bob Smither, Ph.D. 281-331-2744; fax:-4616 Smither@C-C-I.Com
Windows - making simple things easy, and interesting things impossible
======================================================================
Attachments:
c05.htm (text/html, 14.8K) download
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML
><HEAD
><TITLE
>Operators</TITLE
><META
NAME="CREATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.07"><META
NAME="form"
CONTENT="html"></HEAD
><BODY
BGCOLOR="#FFFFFF"
TEXT="#000000"
><TABLE
WIDTH="515"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PostgreSQL User's Guide</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="c0406.htm"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="c06.htm"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="515"><H1
><A
NAME="R,C(5,CHAPTER)"
>Chapter 5. Operators</A
></H1
><P
>Postgres provides a large number of built-in operators on system types.
These operators are declared in the system catalog
pg_operator. Every entry in pg_operator includes
the name of the procedure that implements the operator and the
class OIDs of the input and output types. </P
><P
>To view all variations of the “||” string concatenation operator, try
<PRE
CLASS="PROGRAMLISTING"
> SELECT oprleft, oprright, oprresult, oprcode
FROM pg_operator WHERE oprname = '||';
oprleft|oprright|oprresult|oprcode
-------+--------+---------+-------
25| 25| 25|textcat
1042| 1042| 1042|textcat
1043| 1043| 1043|textcat
(3 rows)</PRE
></P
><P
><DIV
CLASS="TABLE"
><P
><B
>Table 5-1. Postgres Operators</B
></P
><TABLE
BORDER="1"
><TR
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Operator</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Description</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Usage</TH
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> < </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Less than?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>1 < 2</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> <= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Less than or equal to?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>1 <= 2</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> <> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Not equal?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>1 <> 2</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> = </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Equal?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>1 = 1</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> > </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Greater than?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>2 > 1</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> >= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Greater than or equal to?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>2 >= 1</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> || </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Concatenate strings</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'Postgre' || 'SQL'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> !!= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>NOT IN</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>3 !!= i</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ~~ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>LIKE</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'scrappy,marc,hermit' ~~ '%scrappy%'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> !~~ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>NOT LIKE</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'bruce' !~~ '%al%'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ~ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Match (regex), case sensitive</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'thomas' ~ '*.thomas*.'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ~* </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Match (regex), case insensitive</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'thomas' ~* '*.Thomas*.'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> !~ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Does not match (regex), case sensitive</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'thomas' !~ '*.Thomas*.'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> !~* </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Does not match (regex), case insensitive</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'thomas' !~ '*.vadim*.'</TD
></TR
></TABLE
></DIV
></P
><P
><DIV
CLASS="TABLE"
><P
><B
>Table 5-2. Postgres Numerical Operators</B
></P
><TABLE
BORDER="1"
><TR
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Operator</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Description</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Usage</TH
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ! </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Factorial</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>3 !</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> !! </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Factorial (left operator)</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>!! 3</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> % </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Modulo</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>5 % 4</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> % </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Truncate</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>% 4.5</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> * </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Multiplication</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>2 * 3</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> + </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Addition</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>2 + 3</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> - </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Subtraction</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>2 - 3</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> / </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Division</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>4 / 2</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> : </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Natural Exponentiation</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>: 3.0</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ; </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Natural Logarithm</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>(; 5.0)</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> @ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Absolute value</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>@ -5.0</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ^ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Exponentiation</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>2.0 ^ 3.0</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> |/ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Square root</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>|/ 25.0</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ||/ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Cube root</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>||/ 27.0</TD
></TR
></TABLE
></DIV
></P
><P
><DIV
CLASS="TABLE"
><P
><B
>Table 5-3. Postgres Geometric Operators</B
></P
><TABLE
BORDER="1"
><TR
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Operator</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Description</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Usage</TH
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> + </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Translation</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(1,1))'::box + '(2.0,0)'::point</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> - </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Translation</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(1,1))'::box - '(2.0,0)'::point</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> * </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Scaling/rotation</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(1,1))'::box * '(2.0,0)'::point</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> / </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Scaling/rotation</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(2,2))'::box / '(2.0,0)'::point</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> # </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Intersection</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((1,-1),(-1,1))' # '((1,1),(-1,-1))'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> # </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Number of points in polygon</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
># '((1,0),(0,1),(-1,0))'</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ## </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Point of closest proximity</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'(0,0)'::point ## '((2,0),(0,2))'::lseg</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> && </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Overlaps?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(1,1))'::box && '((0,0),(2,2))'::box</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> &< </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Overlaps to left?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(1,1))'::box &< '((0,0),(2,2))'::box</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> &> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Overlaps to right?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(3,3))'::box &> '((0,0),(2,2))'::box</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> <-> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Distance between</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),1)'::circle <-> '((5,0),1)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> << </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Left of?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),1)'::circle << '((5,0),1)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> <^ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is below?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),1)'::circle <^ '((0,5),1)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> >> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is right of?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((5,0),1)'::circle >> '((0,0),1)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> >^ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is above?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,5),1)'::circle >^ '((0,0),1)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ?# </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Intersects or overlaps</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((-1,0),(1,0))'::lseg ?# '((-2,-2),(2,2))'::box;</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ?- </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is horizontal?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'(1,0)'::point ?- '(0,0)'::point</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ?-| </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is perpendicular?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(0,1))'::lseg ?-| '((0,0),(1,0))'::lseg</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> @-@ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Length or circumference</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>@-@ '((0,0),(1,0))'::path</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ?| </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is vertical?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'(0,1)'::point ?| '(0,0)'::point</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ?|| </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Is parallel?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((-1,0),(1,0))'::lseg ?|| '((-1,2),(1,2))'::lseg</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> @ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Contained or on</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'(1,1)'::point @ '((0,0),2)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> @@ </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Center of</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>@@ '((0,0),10)'::circle</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ~= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Same as</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>'((0,0),(1,1))'::polygon ~= '((1,1),(0,0))'::polygon</TD
></TR
></TABLE
></DIV
></P
><P
>The time interval data type tinterval is a legacy from the original
date/time types and is not as well supported as the more modern types. There
are several operators for this type.
<DIV
CLASS="TABLE"
><P
><B
>Table 5-4. Postgres Time Interval Operators</B
></P
><TABLE
BORDER="1"
><TR
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Operator</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Description</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Usage</TH
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> #< </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval less than?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> #<= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval less than or equal to?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> #<> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval not equal?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> #= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval equal?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> #> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval greater than?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> #>= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval greater than or equal to?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> <#> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Convert to time interval</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> << </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Interval less than?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> | </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Start of interval</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> ~= </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Same as</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
> <?> </TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Time inside interval?</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
></TD
></TR
></TABLE
></DIV
></P
><P
>Users may invoke operators using the operator name, as in:
<PRE
CLASS="PROGRAMLISTING"
>select * from emp where salary < 40000;</PRE
>
Alternatively, users may call the functions that implement the
operators directly. In this case, the query above would be expressed
as:
<PRE
CLASS="PROGRAMLISTING"
>select * from emp where int4lt(salary, 40000);</PRE
> </P
><P
>psql
has a <B
CLASS="COMMAND"
>\dd</B
> command to show these operators.</P
><HR
ALIGN="LEFT"
WIDTH="515"><TABLE
WIDTH="515"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="c0406.htm"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="book01.htm"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="c06.htm"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Geometric Types</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
> </TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Functions</TD
></TR
></TABLE
></BODY
></HTML
>
view thread (3+ messages)
Message-ID: <Pine.LNX.3.96.981120181104.23513A-200000@cci.c-c-i.com>
Permalink: ../Pine.LNX.3.96.981120181104.23513A-200000@cci.c-c-i.com/
Also on: postgresql.org/message-id/Pine.LNX.3.96.981120181104.23513A-200000@cci.c-c-i.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: smither@C-C-I.Com, molivier@yahoo.com
Subject: Re: [SQL] abs value, power, sqrt
In-Reply-To: <Pine.LNX.3.96.981120181104.23513A-200000@cci.c-c-i.com>
References: <19981120055303.6281.rocketmail@send105.yahoomail.com> <Pine.LNX.3.96.981120181104.23513A-200000@cci.c-c-i.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox