Re: random row from a subset

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: bluefrog <pkoukoulis(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: random row from a subset
Date: 2017-09-20 12:30:12
Message-ID: d4452ddb-8d20-0183-44d3-863cfee9e626@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/20/2017 01:28 PM, bluefrog wrote:
>
> thanks, interestingly your method works in both Oracle and PostgreSQL,
> albeit with a different random function call.
> It does not work in SQL Anywhere though.
>

You will have to ask SQL Anywhere people, I guess.

cheers

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2017-09-20 12:59:30 Re: VM-Ware Backup of VM safe?
Previous Message Dave Cramer 2017-09-20 12:22:26 Re: [GENERAL] JDBC: logical replication and LSN feedback