Posts by Carlos Henrique • 1 point
4 posts
-
0
votes1
answer44
viewsA: ERROR: table name "mytableteste" specified more than Once
I managed to tidy up here with subquery as ( select * from mytableteste INNER JOIN ( SELECT ROW_NUMBER() OVER (ORDER BY numg_iddoobject) AS Rn, numg_iddoobject as numg_iddoobjetoC from mytabletest )…
-
0
votes1
answer44
viewsQ: ERROR: table name "mytableteste" specified more than Once
to try to do this query to "shuffle" the table data. This same query worked in mysql, but not in postgresql. always get this error [Code: 0, SQL State: 42712] ERROR: table name "mytableteste"…
-
0
votes0
answers199
viewsQ: Validate Cpf’s of an sql query
Good afternoon people, I have the code below to validate Cpf and cnpj However, when trying to call the sql function, it does not execute because of the following error: [Code: 6552, SQL State:…
-
0
votes1
answer311
viewsQ: Validate Cpf’s from a query
Opa gente, to trying to validate the cpfs of a query, are several Cpf"s. I have the following function to validate Cpf, but I’m not getting call-there I’m trying to do it like this: SELECT…