Je suis au niveau 3 avec sites3
Je dois chercher Sudan dans site
Cherchons le type de site
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'sites' AND a.attname = 'site' AND a.attnum > 0 AND n.nspname = 'public'site vaut : S
Je dois chercher Sudan dans region_fr
Cherchons le type de region_fr
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'sites' AND a.attname = 'region_fr' AND a.attnum > 0 AND n.nspname = 'public'region_fr vaut : S
Je dois chercher Sudan dans region_en
Cherchons le type de region_en
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'sites' AND a.attname = 'region_en' AND a.attnum > 0 AND n.nspname = 'public'region_en vaut : S
Erreur SQL lim :
ERROR: invalid reference to FROM-clause entry for table "sites" LINE 1: ...(true=true) AND ( TRUE AND TRUE AND TRUE AND (((sites.site... ^ HINT: Perhaps you meant to reference the table alias "sites3".