PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gábriel Ákos
Sent: Tuesday, March 28, 2006 12:34 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Update question
Markus Schaber wrote:
> Hi, Fay,
>
> Fay Du wrote:
>> Table cost
>>
>> Id edge_idcost
>&
Markus Schaber wrote:
Hi, Fay,
Fay Du wrote:
Table cost
Id edge_idcost
1 30 101.4
2 30 null
3 40 500.2
4 40 null
545 300.7
645 null
I want to set cost value with same edge_id by same value. T
Hi, Fay,
Fay Du wrote:
> Table cost
>
> Id edge_idcost
> 1 30 101.4
> 2 30 null
> 3 40 500.2
> 4 40 null
> 545 300.7
> 645 null
> I want to set cost value with same edge_id by same value. The exis
Matthew Peter <[EMAIL PROTECTED]> writes:
> it's in a loop so there's an extra comma at the end so i was thinking i
> could put in a throw away value to keep the update from breaking if there's
> an additional comma
The best thing is to fix your loop logic. Usually it's not hard to emit
a com
On 12/5/05, Matthew Peter <[EMAIL PROTECTED]> wrote:
> it's in a loop so there's an extra comma at the end so i was thinking i
> could put in a throw away value to keep the update from breaking if there's
> an additional comma
>
> Jaime Casanova <[EMAIL PROTECTED]> wrote:
> On 12/5/05, Matthew Pete
Like WHERE 1 = 1, but in UPDATE table SET value = 1, 1 = 1;
Yahoo! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Try Yahoo! Personals
it's in a loop so there's an extra comma at the end so i was thinking i could put in a throw away value to keep the update from breaking if there's an additional commaJaime Casanova <[EMAIL PROTECTED]> wrote: On 12/5/05, Matthew Peter wrote:> I need a throw away value for an insert statement...
On 12/5/05, Matthew Peter <[EMAIL PROTECTED]> wrote:
> I need a throw away value for an insert statement... example...
>
> update table
> set value = 1, value = 2, throw_away_value -- so i don't break the query
> where id = 1;
>
> Thanks
>
What do you mean by "throw away value"?
are you trying to
