Re: limit table to one row

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: limit table to one row
Date: 2009-06-10 12:19:55
Message-ID: h0o8db$7jc$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2009-06-09, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote:
> 2009/6/9 Brandon Metcalf <brandon(at)geronimoalloys(dot)com>:
>
>
>> I'm not sure I follow how this solves the problem.
>
> Well, surely if you just need one row, you need single value per key.
> And that's the, imo , better solution to that problem, than limiting
> number of rows.

not really, if different keys have different types of values
associated.

one application I work with has a config table with atleast text, integer,
interval, and boolean values.

>
>
> --
> GJ
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nykolyn, Andrew P (AS) 2009-06-10 12:38:26 Re: Upgrade from Postgres 8.2.4 to 8.3.5
Previous Message Bill Moran 2009-06-10 12:14:30 Re: Postgres's Performance degrades after heavy db operation