Does the same thing happen if you select from Psalms, or Thessalonians,
instead of Proverbs? Sorry. Little religion humor. Too early in the
morning and I haven't had my coffee, yet.
On Fri, Nov 11, 2016 at 4:34 AM, Cecil Westerhof
wrote:
> 2016-11-11 11:22 GMT+01:00 Clemens Ladisch :
> > Cecil
2016-11-11 11:22 GMT+01:00 Clemens Ladisch :
> Cecil Westerhof wrote:
>> When I execute the following query:
>> SELECT *, randomiser * 1000
>> FROM (SELECT abs(random()) / 1 AS randomiser);
>>
>> I get normal results:
>> 61|61000
>>
>> But when I change it to:
>> SELECT *, randomise
2016-11-11 11:01 GMT+01:00 Cecil Westerhof :
> When I execute the following query:
> SELECT *
> , randomiser * 1000
> FROM (
> SELECT abs(random()) / 1 AS randomiser
> );
>
> I get normal results:
> 61|61000
>
>
> But when I change it to:
> SELECT *
> , randomiser * 10
Cecil Westerhof wrote:
> When I execute the following query:
> SELECT *, randomiser * 1000
> FROM (SELECT abs(random()) / 1 AS randomiser);
>
> I get normal results:
> 61|61000
>
> But when I change it to:
> SELECT *, randomiser * 1000
> FROM (SELECT abs(random()) / 1000
When I execute the following query:
SELECT *
, randomiser * 1000
FROM (
SELECT abs(random()) / 1 AS randomiser
);
I get normal results:
61|61000
But when I change it to:
SELECT *
, randomiser * 1000
FROM (
SELECT abs(random()) / 1 AS randomiser
5 matches
Mail list logo