[SQL] demo of using large objects interface in php

2000-09-14 Thread danny
Hi, Finally, I can give the demo of using large objects interface in php. the test table: create table lo_test ( id serial, raster oid, primary key(id) ); file: lo_insert.php \n"; $handle = pg_loopen ($db, $oid, "w"); echo ("handle=$handle\n"); $fp = fopen ("/etc/rc.d

Re: [SQL] left and outer joins?

2000-09-14 Thread Stephan Szabo
If you were looking in just -sql, you'll have missed out on the later information which was on -hackers... I believe Tom Lane just committed changes recently to put in support for them with a few caveats, so unless something comes up, you should see some support in 7.1. On Thu, 14 Sep 2000, M

Re: [SQL] Optimizing Multiply Joins ???

2000-09-14 Thread Tom Lane
Meszaros Attila <[EMAIL PROTECTED]> writes: > Can I test this feature in the current snapshot? Sure. But see my message to pghackers on Tuesday for notes about what's not working yet in the JOIN support. regards, tom lane

[SQL] left and outer joins?

2000-09-14 Thread Michael Teter
I see in the TODO that left and outer joins are supposedly a priority. I do wonder what the status is, since the email correspondence shows the most recent email as being from something like march or july of 1999. what is the status on left and outer joins? thanks michael _

Re: [SQL] Web Hosts (off-topic)

2000-09-14 Thread Peter Mount
At work, were using dedicated-servers.co.uk for our new sites. They use Redhat 6.2, but I compiled both php4 and PostgreSQL 7.0.2 and it's running smoothly. -- Peter T Mount [EMAIL PROTECTED] http://www.retep.org.uk PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/ Java PDF Generator http

Re: [SQL] Optimizing Multiply Joins ???

2000-09-14 Thread Meszaros Attila
Hi, > If that's what you write, yes. You can parenthesize the JOIN clauses > any way you like, though, and the 7.1 planner will follow that structure. Thanks for the exhaustive answer. Can I test this feature in the current snapshot? Attila

Re: [SQL] Optimizing Multiply Joins ???

2000-09-14 Thread Tom Lane
Meszaros Attila <[EMAIL PROTECTED]> writes: >> Actually, as the 7.1 code currently stands, a query that uses explicit >> JOIN operators like yours does will always be implemented in exactly >> the given join order, with no searching. I haven't quite decided if >> that's a bug or a feature ... >

Re: [SQL] Optimizing Multiply Joins ???

2000-09-14 Thread Meszaros Attila
Hi, > Actually, as the 7.1 code currently stands, a query that uses explicit > JOIN operators like yours does will always be implemented in exactly > the given join order, with no searching. I haven't quite decided if > that's a bug or a feature ... Do you mean a "linear binary tree" li