Hi Tom,
Yes. It looks like that works properly. And I'm replying because I had a
hard time to write the actual SQL command! I put it below.
It looks like your page about the joins would need a few examples. I tried
different syntax and they didn't work (thought they are valid for MySQL or
Orac
"Alexis Wilke" <[EMAIL PROTECTED]> writes:
> -- In this select, it detects that the phpbb_topics_watch is
> -- empty and thus ignores the WHERE clause thinking since that
> -- table is empty the SELECT will be empty
> SELECT 'The next SELECT finds 0 row. It should find the same row!' AS
> message;
The following bug has been logged online:
Bug reference: 2237
Logged by: Alexis Wilke
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Linux (RH9)
Description:SELECT optimizer drops everything improperly
Details:
Hi guys,
It looks like i
