Re: limit table to one row - Mailing list pgsql-general

From Jasen Betts
Subject Re: limit table to one row
Date
Msg-id h0o8db$7jc$1@reversiblemaps.ath.cx
Whole thread Raw
In response to limit table to one row  (Brandon Metcalf <brandon@geronimoalloys.com>)
List pgsql-general
On 2009-06-09, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> 2009/6/9 Brandon Metcalf <brandon@geronimoalloys.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
>


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Postgres's Performance degrades after heavy db operation
Next
From: "Nykolyn, Andrew P (AS)"
Date:
Subject: Re: Upgrade from Postgres 8.2.4 to 8.3.5