|
Hello, there
I installed PostgreSQL on windows and when I try to
run some queries pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef
FROM pg_attribute WHERE attrelid=pg_class.oid AND pg_class.relname='client_overtime' AND attname='id_client_overtime' This query works fine in PostgreSQL (Linux-Unix
platform)
Thx
|
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.10/218 - Release Date: 02/01/2006
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
