On Thu, 26 Jun 2008 19:49:01 -0400 (EDT)
"Patricia Mitchell"<[EMAIL PROTECTED]> wrote:
> The columns (a,b,c) of the navigation table should not appear in the
> result because you are only pulling records from the product and item
> table. You are pulling the records out of the product and item ta
am Fri, dem 27.06.2008, um 0:35:38 +0100 mailte Tarlika Elisabeth Schmitz
folgendes:
>
> SELECT DISTINCT a, b, c, now(), count(item_pk)
> FROM product
> LEFT JOIN item ON item.product_fk = product_pk
> WHERE ...
> GROUP BY a, b, c
>
>
> I have another table 'navigation' which also has the co
SELECT DISTINCT a, b, c, now(), count(item_pk)
FROM product
LEFT JOIN item ON item.product_fk = product_pk
WHERE ...
GROUP BY a, b, c
I have another table 'navigation' which also has the columns a,b,c
If the combination of (a,b,c) exists in 'navigation', then exclude it
from above result. How
- Try SQL 2003 standards92 is way old
- You'll find that even the big boys like Oracle, DB2 etc will diverge from
SQL standards if they make more $$ thier way...let alone toys like MySQL and
MS-SQL
Cheers
Medi
On Thu, Jun 26, 2008 at 12:19 PM, Steve Midgley <[EMAIL PROTECTED]> wrote:
> At 02
At 02:20 AM 6/25/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 24 Jun 2008 17:33:11 +0300
From: "Pascal Tufenkji" <[EMAIL PROTECTED]>
To:
Subject: ANSI Standard
Message-ID: <[EMAIL PROTECTED]>
Hi,
How do I know if a function (or a certain sql syntax) in Postgres is a
SQL
ANSI Standard, hence it
Hello,
I guess that the time offsets (now-21 and now-28) are evaluated each
time the corresponding condition is met.
It may be faster to put them into a separate sub query. I'm not sure
about putting "now" itself within the sub query...
It may also be better to put your query in a procedure wher
