Well, it could make some sense to extend the semantics when you have
explicit "REFERENCES" to tables in the JOINs.Or at least warn or notice the
user that the "NATURAL (INNER) JOIN" has actuallt been converted into a
CROSS one.
It would not be standard but helpful for developers.
Thanks.
2008/10/
Hi all.
I usually create indexes accordingly to the queries used in my software.
This means the more often than not I have composited indexes over more than
one column.
What'd be in PGSQL (v8.3+) the pros and cons of having instead only
one-column indexes?
Thanks in advance.
RMP.
HI all.
Is there a way to CREATE a DOMAIN in v8.3 with a CHECK() predicate to ensure
the value is in a dictionary table?
Of course, I already know the trivial and ugly solution with a (PL/Pg)SQL
lookup function.
Thanks.
