Re: Selecting pairs of numbers

From: "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org>
To: "'Adrian Klaver'" <adrian(dot)klaver(at)aklaver(dot)com>, <rod(at)iol(dot)ie>, "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Selecting pairs of numbers
Date: 2015-10-06 05:15:39
Message-ID: 06c501d0fff6$11e6f210$35b4d630$@swisspug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> aklaver(at)test=> create table pr_test(x int, y int);
>
> aklaver(at)test=> select * from pr_test where (x, y) between (1, 3) and
> (3,2) order by x,y;
> x | y
> ---+---
> 1 | 3
> 1 | 4
> 2 | 1
> 2 | 2
> 2 | 3
> 2 | 4
> 3 | 1
> 3 | 2

+1, nice.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2015-10-06 05:35:33 Re: BDR Rejoin of failed node, hangs.
Previous Message Sachin Srivastava 2015-10-06 04:52:16 How to reduce pg_dump backup time