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 Tue, Dec 06, 2005 at 02:00:18 +0100,
Erik Sigra <[EMAIL PROTECTED]> wrote:
> Thanks for the hint! I thought I need to put the triggers on
> materialized views. If I would have to put them on the base tables, the
> application program would have to understand the query to figure out
> which tab
Bruno Wolff III wrote:
On Mon, Dec 05, 2005 at 19:22:22 +0100,
Erik Sigra <[EMAIL PROTECTED]> wrote:
Hi,
I plan to develop an application that is somewhat like a spreadsheet
with cells containing formulas. When a cell value is changed, things
must be updated. But the formulas can contain da
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
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
Yahoo! Personals
Let fate take it's course directly to your email.
See who's waiting for you Yahoo! Personals
I think I have a similar situation involving the naming of assets, where
the usual asset description is used, but users can enter a description in
a separate table which 'overrides' the original name with a name that is
more familiar to the individual.
IF THIS IS WHAT YOU WANT, it was accomplishe
On Mon, Dec 05, 2005 at 19:22:22 +0100,
Erik Sigra <[EMAIL PROTECTED]> wrote:
> Hi,
> I plan to develop an application that is somewhat like a spreadsheet
> with cells containing formulas. When a cell value is changed, things
> must be updated. But the formulas can contain database queries, which
Hello,
I am in a situation where I have various tables (including data such as
a product list) that are read-only to me. I wish to provide the
functionality of changing this table: Removing items, modifying items,
creating new ones. My original idea is to use a second table that is
formatte
Hi,
I plan to develop an application that is somewhat like a spreadsheet
with cells containing formulas. When a cell value is changed, things
must be updated. But the formulas can contain database queries, which
means that the cell has to be notified when the database changes in such
a way that t
Mark Fenbers wrote:
What would have to be done if I needed a standard SQL solution?
Mark
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Maybe you could t'ry something like :
Se
13 matches
Mail list logo
