Thread: Re: pg_generate_sequence and info_schema patch (Was: SE

Re: pg_generate_sequence and info_schema patch (Was: SE

From
Claudio Natoli
Date:
> The one corner case not discussed is a step size of zero.
> Currently it returns zero rows, but I considered having it generate an
ERROR.

Following on from my previous comments, MatLab also returns an empty matrix
in this condition.

[Of course, whether or not this is the best behaviour (as opposed to error)
is an arguable point.]

Cheers,
Claudio

---
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
<a
href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em
ailpolicy.html</a>

Re: pg_generate_sequence and info_schema patch (Was: SE

From
Joe Conway
Date:
Claudio Natoli wrote:
> [Of course, whether or not this is the best behaviour (as opposed to error)
> is an arguable point.]

Thanks for the input. I think I'll go with Tom's nearby advice and make
it an error.

Joe