Re: pg_generate_sequence and info_schema patch (Was: SE

From: Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com>
To: 'Tom Lane ' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 'Joe Conway ' <mail(at)joeconway(dot)com>
Cc: 'Kris Jurka ' <books(at)ejurka(dot)com>, 'Alex ' <alex(at)meerkatsoft(dot)com>, 'Lada 'Ray' Lostak ' <ray(at)unreal64(dot)net>, "'pgsql-patches(at)postgresql(dot)org '" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_generate_sequence and info_schema patch (Was: SE
Date: 2004-02-01 23:04:17
Message-ID: A02DEC4D1073D611BAE8525405FCCE2B55F2B2@harris.memetrics.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Tom Lane wrote:
> If you want to allow the 3-parameter form to specify a negative step
> size, that's fine. But don't use a heuristic to guess the intended
> step direction.

Have to agree. Ever used MatLab? They have a fairly intuitive approach:

1:5 => [1 2 3 4]

1:2:5 => [1 3 5]

5:1 => empty matrix

5:-1:1 => [5 4 3 2 1]

Basically, step size is assumed to be +1, unless provided (in their syntax,
as the second argument when 3 arguments are given). Empty ranges produce an
emty result.

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>

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-02-01 23:11:11 Re: C locale sort in src/tools/make_ctags
Previous Message Tom Lane 2004-02-01 21:12:41 Re: pg_generate_sequence and info_schema patch (Was: SELECT Question)