| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Marco Bizzarri <marco(dot)bizzarri(at)gmail(dot)com> |
| Cc: | PgSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Advice on implementing counters in postgreSQL |
| Date: | 2008-08-02 15:11:43 |
| Message-ID: | 20080802151143.GB16373@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Aug 02, 2008 at 09:23:31AM +0200, Marco Bizzarri wrote:
> Hi all.
>
> I need to keep a numer of counters in my application; my counters
> are currently stored in a table:
>
> name | next_value | year
>
> The counters must be progressive numbers with no holes in between
> them, and they must restart from 1 every year.
Here's a backward-compatible way to do this:
http://www.varlena.com/GeneralBits/130.php
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sushant Sinha | 2008-08-02 15:50:18 | Re: [GENERAL] Fragments in tsearch2 headline |
| Previous Message | johnf | 2008-08-02 14:14:44 | Re: Is there any reason why "edit PostgreSQL.conf should be on my menu" |