Re: pg_generate_sequence and info_schema patch (Was: SE

From: Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com>
To: 'Joe Conway' <mail(at)joeconway(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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
Subject: Re: pg_generate_sequence and info_schema patch (Was: SE
Date: 2004-02-02 06:53:05
Message-ID: A02DEC4D1073D611BAE8525405FCCE2B55F2BF@harris.memetrics.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


> 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>

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Claudio Natoli 2004-02-02 07:17:51 Re: [pgsql-hackers-win32] Proposed dirmod.c fix for Win32
Previous Message Tom Lane 2004-02-02 06:44:18 Re: pg_generate_sequence and info_schema patch (Was: SELECT Question)