From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: Andreas Kretschmer <akretschmer@spamfence.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Inc
Date: Tue, 6 Mar 2007 15:02:07 -0300
Message-ID: <55c095e90703061002u421b962dy6ab15fcdc7d5fb0c@mail.gmail.com> (raw)
In-Reply-To: <20070306175407.GA20988@KanotixBox>
References: <55c095e90703060929w745cd560g12426c986b75e430@mail.gmail.com>
<52066.31587.qm@web31815.mail.mud.yahoo.com>
<20070306175407.GA20988@KanotixBox>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ezequias.rocha@gmail.com, akretschmer@spamfence.net
Subject: Re: Inc
In-Reply-To: <55c095e90703061002u421b962dy6ab15fcdc7d5fb0c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox