Postgres Pro
Downloads
Home   >   mailing lists

Re: selective updates - Mailing list pgsql-sql

From Gianluca Riccardi
Subject Re: selective updates
Date
Msg-id 43A18D46.6060201@moonwatcher.it
Whole thread Raw
In response to selective updates  (Gianluca Riccardi <ml-reader@moonwatcher.it>)
List pgsql-sql
Tree view 
Gianluca Riccardi wrote:
[cut]

solved,

i used a function giving as result the wanted value from table2.column1
in a UPDATE table1 SET column4=(my_personal_func()) WHERE 'cirteria on 
table1.column2 table2.column2' ;

sorry for making you wasting your time

Gianluca Riccardi

pgsql-sql by date:

Previous
From: grupos
Date:
Subject: RETURN SET OF DATA WITH CURSOR
Next
From: Richard Huxton
Date:
Subject: Re: RETURN SET OF DATA WITH CURSOR