Iam sorry for the previous mail..it was in complete. Please do not
consider it.
I think i could figure out the problem for the updates not happening.
Following is the function that does the update :
BEGIN
IF flag=1 THEN
tempQuery:='UPDATE '||thepartition||' SET
volume='||update
I tried getting the output of the execute statements by printing the
FOUND variable. It is returning the value as false.
However i used PEFORM instead of EXECUTE for the update statement. It
On 6/3/08, samantha mahindrakar <[EMAIL PROTECTED]> wrote:
> Hi
> Iam facing a strange issue
> One
Hi
Iam facing a strange issue
One of the functions in my program is running an update statement. The
statement is running cross-schema. What i mean is that the program
resides in one schema where as it updates a table from another schema.
How ever these scehmas are on the same database.
The
On Tue, Apr 03, 2007 at 09:13:00AM +0200, Shavonne Marietta Wijesinghe wrote:
> Thanks. But to do the UPDATE i have to write each column name (for recrd 4)
> and with its column name (for record 2) which is quite alot to write :P
>
> UPDATE MOD48_00_2007 SET te_cognome= te_cognome, te_paternita=
column name = to the column
name.
And i have to do it for echt field? isn't there any other way..
"I hate writting :P"
And Andrew can explain a bit the setval()
Thanks
Shavonne Wijesinghe
From: "Andrew Sullivan" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 02, 2007 5:
On Mon, Apr 02, 2007 at 04:52:46PM +0200, Shavonne Marietta Wijesinghe wrote:
> At a surtain point i need to replace a record with another
>
> For example i have inserted 4 records. (1, 2 , 3 , 4) I need to
> replace all the values from the record 4 to the record 2 but
> keeping the n_gen serial
Hello
I have a table created as the following
CREATE TABLE mod48_00_2007
(
id text,
n_gen serial NOT NULL,
formstore text,
te_cognome text,
te_paternita text,
te_nome text,
te_sesso text,
te_dtnasc text,
te_attnasc text,
te_luonasc text,
te_provstato text,
te_indi text,
Hello
I have a table created as the following
CREATE TABLE mod48_00_2007
(
id text,
n_gen serial NOT NULL,
formstore text,
te_cognome text,
te_paternita text,
te_nome text,
te_sesso text,
te_dtnasc text,
te_attnasc text,
te_luonasc text,
te_provstato text,
te_indi text,
On Tue, Jun 06, 2006 at 01:04:26PM -, Christian Paul Cosinas wrote:
>
>
> Sometimes only column1 and column2 is updated and column3 is not updated.
Column 3 was already set to 08:00 AM?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking
Hi,
I’m encountering some weird problem on Update.
I have a program that updates a table and it updates more
than 1 column at a single query.
Like this one:
Update table1 set column1 = ‘a’, column2 = ‘b’,
column3 = time ’08:00 AM’ where column1 = ‘c’
Sometimes only column1
10 matches
Mail list logo
