Re: Inc - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Re: Inc
Date
Msg-id 55c095e90703061002u421b962dy6ab15fcdc7d5fb0c@mail.gmail.com
Whole thread Raw
In response to Re: Inc  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-sql
Now that's ok. Thank you all. I just thought that there was a function
to inc an integer field in postgresql.

Best regards
Ezequias

2007/3/6, Andreas Kretschmer <akretschmer@spamfence.net>:
> Richard Broersma Jr <rabroersma@yahoo.com> schrieb:
>
> > --- Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> >
> > > Thank you but I must inc an specific row. How to do that ?
> > >
> >
> > Does,
> >
> > UPDATE your_table
> > SET your_row = your_row +1
> > WHERE your_pkey = <some value>;
> >
> > not do what you need?
>
> I think, he is searching for a TRIGGER and he has got the solution.
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect.                              (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly."    (unknow)
> Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Inc
Next
From: Stefan Becker
Date:
Subject: Re: Selecting exactly one row for each column value