Re: [BUGS] BUG #2553: Outer join bug
[Please copy the mailing list on replies so others can participate in and learn from the discussion.] On Fri, Jul 28, 2006 at 09:54:42AM -0500, Steven Adams wrote: > I wanted the row to show whether or not there was a matching row in the > other table, but I wanted to return exactly 1 row. As Tom Lane already pointed out, you're probably needing a WHERE clause. Does this do what you want? SELECT ia.name, iac.internal FROM information_assets AS ia LEFT OUTER JOIN information_asset_categories AS iac ON ia.category_id = iac.id WHERE ia.id = 21; -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] Query returned unhandled type 16411
Roger Merritt wrote: Hi, I have tried several installs of postgresql-8.1.3-1 and postgresql-8.1.4-1, with psqlodbc-08_02_0002.zip and PgOleDb-1.0.0.20.zip. After each uninstall I delete the entire contents of the C:\Program Files\PostgreSQL directory. I am using VB6 SP6b. My 'Connection' string is: Provider=PostgreSQL OLE DB Provider;Password=xx;User ID=postgres;Data Source=127.0.0.1;Location=spatial;Extended Properties="" When the following code runs against a table with a geometry column I get the following error: Query returned unhandled type 16411 It looks like the odbc/ole-db drivers don't know anything about the geometry types. That's not terribly surprising, since I don't know of any MS-standard modeling polygons circles etc. as database objects. Presumably any custom types you design will have the same problem too. Hmm - it's presumably non-trivial to add type handling for the Windows drivers without a C compiler and associated tools. Your best bet is to contact the odbc/ole-db mailing lists and see if they have any bright ideas. An option to handle unrecognised types as text could make sense. It might be you can work-around the problem for the moment by accessing a view that does the cast-to-text for the geometry columns. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
