From: Jean-Luc Lachance <jllachan@nsd.ca>
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Re: How to update record in a specified order
Date: Fri, 09 Aug 2002 17:59:49 -0400
Message-ID: <3D543B55.CE5F5DEF@nsd.ca> (raw)
References: <no.Yo.N.nN.0208091642320.2280-100000@business.com>
<3D54326E.EB235934@nsd.ca>
<200208091437.52702.josh@agliodbs.com>
As in an order by clause... If it existed.
Josh Berkus wrote:
>
> JLL,
>
> > I want to update a field with a 'NEXTVAL', but I want the record updated
> > in a specific order.
> > Any simple way of doing this other than having to create a temp table?
>
> Please be more speciifc. What do you mean, "specified order"?
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
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: jllachan@nsd.ca, josh@agliodbs.com
Subject: Re: How to update record in a specified order
In-Reply-To: <3D543B55.CE5F5DEF@nsd.ca>
* 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