0
I created a column included in the app table, it works to record the purchase date of the app and I will have to update the old records with the user creation date. I made a query to solve the problem, but postgresql accuses an error:
ERROR: table name "app" specified more than Once
This is my query:
UPDATE app
SET app.inclusao = usuario.inclusao
FROM app, usuario
WHERE app.usuario = usuario.codigo
How do I fix this?
ERROR: column "app" of relation "app" does not exist
didn’t work.– VitorLuizC
Now go, typed wrong app. ;D
– VitorLuizC
@Haxz if the answer solved your problem, mark it as correct.
– Randrade