update and inherits

From: "Jonathan davis" <haj(at)idianet(dot)net>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: update and inherits
Date: 1999-07-07 15:43:11
Message-ID: 000e01bec88f$6b64cfc0$0601a8c0@kosovo.idianet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>i want to : update virtual_table set field1 = 3 where index = 4;
>
>create table virtual_table(index int4, field1 int4);
>
>create table table1 ( ....)inherits(virtual_table);
>
>create table table2( ....)inherits(virtual_table);
>
>insert into table1(index, field1) values(4, 0);
>
>and i want to change the value of field1
>
>

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Good 1999-07-07 16:15:50 July 1999 issue of Sys Admin
Previous Message Jonathan davis 1999-07-07 15:08:23 Re: [GENERAL] Problems with inequalities on numeric fields in 6.5