[GENERAL] UPDATE Inserts New Rows

2005-05-11 Thread Ruben Oliveira
6,3) | not null default 0.000 field7 | text | not null default ''::text Indexes: "table084_pkey" PRIMARY KEY, btree (field1, field2) Am I missing something ? I can give you more details if needed. Thanks for any help ... Ruben Oliveira ---(e

Re: [GENERAL] UPDATE Inserts New Rows

2005-05-11 Thread Ruben Oliveira
an simple select would make it clear that the aplication that uses the DB was already doing the INSERT, shame on me :( Thanks for everything :) Ruben Oliveira Richard Huxton wrote: Ruben Oliveira wrote: I'm having an unexpected behavior from an UPDATE query : I expected only updates to exist

[GENERAL] problem with dots in order by

2005-02-15 Thread Ruben Oliveira
Hello everybody ! I have this order by : select lalala from tablex order by field_y; where field_y is a text column. that returns something like : 2.1004.11 21.00.461 2.1006.21 in PostgreSQL 7.3.2 in Linux Mandrake 9.1 but in PostgreSQL 8.0.0 in Windows XP it works as I expected ... 2.1004.11 2.10

Re: [GENERAL] problem with dots in order by

2005-02-15 Thread Ruben Oliveira
some other machine the initdb --locale=C just to be safe ... Thanks again , Ruben Oliveira - Tom Lane wrote: Ruben Oliveira <[EMAIL PROTECTED]> writes: Can anybody tell me if there is something I can do in the Linux config to have the same order by result ?? Sort order is determine