On 09/01/10 16:13, Igor Neyman wrote:
-Original Message-
From: Raymond C. Rodgers [mailto:sinful...@gmail.com]
Sent: Tuesday, August 31, 2010 7:56 PM
To: pgsql-general@postgresql.org
Subject: Table update problem works on MySQL but not Postgres
update mydemo set cat_order = cat_orde
> -Original Message-
> From: Raymond C. Rodgers [mailto:sinful...@gmail.com]
> Sent: Tuesday, August 31, 2010 7:56 PM
> To: pgsql-general@postgresql.org
> Subject: Table update problem works on MySQL but not Postgres
>
> Let me stress that this is not a bug in PostgreSQL; if
> anyth
On 8/31/2010 8:17 PM, Merlin Moncure wrote:
On Tue, Aug 31, 2010 at 7:56 PM, Raymond C. Rodgers wrote:
Let me stress that this is not a bug in PostgreSQL; if anything at all,
it's only a lack of a stupid feature.
I'm working on a project for a client where I have a table for arbitrary
categ
On Tue, 2010-08-31 at 20:17 -0400, Merlin Moncure wrote:
> > This is where the interesting thing happens: On MySQL the query actually
> > works as intended, but it doesn't on PostgreSQL. As I said, I'm sure this is
> > not a bug in PostgreSQL, but the lack of a stupid user trick. While my
> > proj
On Tue, Aug 31, 2010 at 7:56 PM, Raymond C. Rodgers wrote:
> Let me stress that this is not a bug in PostgreSQL; if anything at all,
> it's only a lack of a stupid feature.
>
> I'm working on a project for a client where I have a table for arbitrary
> categories to be applied to their data, and t
On Tue, Aug 31, 2010 at 07:56:23PM -0400, Raymond C. Rodgers wrote:
> Let me stress that this is not a bug in PostgreSQL; if anything at
> all, it's only a lack of a stupid feature.
PostgreSQL's version involves UPDATE ... FROM. Use an ORDER BY in the
FROM clause like this:
UPDATE mydemo SET ca
Let me stress that this is not a bug in PostgreSQL; if anything at
all, it's only a lack of a stupid feature.
I'm working on a project for a client where I have a table for arbitrary
categories to be applied to their data, and they need to be able to set
the order in which the categories appe