Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 9BD1F9FB647
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  6 Mar 2007 14:02:16 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 84199-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  6 Mar 2007 14:02:11 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171])
	by postgresql.org (Postfix) with ESMTP id 830B19FB2DD
	for <pgsql-sql@postgresql.org>; Tue,  6 Mar 2007 14:02:09 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so255480ugf
	for <pgsql-sql@postgresql.org>; Tue, 06 Mar 2007 10:02:07 -0800 (PST)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=CMuvP5LNdTvIE+556V+PQpwqWolDipi58zZDilaMxZF6STOV2PrJT5exxCdjTgom1YHZ+ulmu6HWsx/SZHNsuJZIUjGZQHUKqagEfrLkEnh/aktdp7yH7bmVeupRa1B6qRlkhO6lgTMhRIa+qvN9h8/EtA8kZzuzYrI98oKxaZo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=IwW8aFmnzMFMuCcHcT1ctM0fUn/TbPPZBNoUZU5b/QUHUaRNt9nMH8zJrd9JUaLBT4Y0AyO4KyVJYckQ43+4fOxCn4+evaCGq+uhDJNoCvdazTYriG1IcdwP5Oh4TTe1FvuagMNU0nEVpOkI2yDqSZTXPW9k3M1EJEw4MzjSgn4=
Received: by 10.67.106.3 with SMTP id i3mr2139251ugm.1173204127677;
	Tue, 06 Mar 2007 10:02:07 -0800 (PST)
Received: by 10.67.94.13 with HTTP; Tue, 6 Mar 2007 10:02:07 -0800 (PST)
Message-ID: <55c095e90703061002u421b962dy6ab15fcdc7d5fb0c@mail.gmail.com>
Date: Tue, 6 Mar 2007 15:02:07 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "Andreas Kretschmer" <akretschmer@spamfence.net>
Subject: Re: Inc
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20070306175407.GA20988@KanotixBox>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <55c095e90703060929w745cd560g12426c986b75e430@mail.gmail.com>
	<52066.31587.qm@web31815.mail.mud.yahoo.com>
	<20070306175407.GA20988@KanotixBox>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/57
X-Sequence-Number: 27695

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 =3D your_row +1
> > WHERE your_pkey =3D <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=B0, E 13.56889=
=B0
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>