Re: Sequences without blank holes - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Sequences without blank holes
Date
Msg-id 20031106143304.GB18854@wolff.to
Whole thread Raw
In response to Sequences without blank holes  (MaRcElO PeReIrA <gandalf_mp@yahoo.com.br>)
List pgsql-general
On Thu, Nov 06, 2003 at 05:01:54 -0300,
  MaRcElO PeReIrA <gandalf_mp@yahoo.com.br> wrote:
>
> $ select * from products;
> prod_id |     description
> --------+---------------------
>      1  | S470DXBLM
>     12  | S470DXABM
>     33  | RG250DX
> --------+---------------------
> (3 rows)
>
> and it is ok to me, but not to the users.

I aggree with the suggestion not to show them the internal keys.
The values in the description field look a lot more like product IDs
to me than descriptions. Maybe you should just use those when interacting
with the users.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Problems with PLPGSQL
Next
From: George Essig
Date:
Subject: Re: tsearch2 and gist index bloat