PG Version 8.1

From: Diego <diego(at)unimedijui(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: PG Version 8.1
Date: 2005-11-22 11:34:39
Message-ID: 4383024F.6000406@unimedijui.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, i use pg version 8.0 and i have this case:

UPDATE tbpeople
SET dt_update = '11/22/2005'
WHERE tbdoctor.id_people = tbpeople.id

But now, in version 8.1, this instrution give me an error:
[ERROR: missing FROM-clause entry for table "tbdoctor"]

Who can i do now to get the same result?

Thanks...
Diego Ziquinatti

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2005-11-22 12:05:01 Re: Max no of commands per transaction
Previous Message John Barham 2005-11-22 10:40:17 Re: PG Version 8.1