Re: Aliased table names ...oddity?

i think this is related to a pgsql gotcha... see
1.1...

http://sql-info.de/postgresql/postgres-gotchas.html

--- "Obe, Regina DND\\MIS"
<robe(dot)dnd(at)cityofboston(dot)gov> wrote:

> Yes - in the postgresql.conf there is an
> "add_missing_from" option - change
> that to false. I think by default it is on, and in
> future versions they are
> planning to set that to false.
>
> -----Original Message-----
> From: Steve Tucknott [mailto:steve(at)retsol(dot)co(dot)uk]
> Sent: Thursday, June 30, 2005 2:55 AM
> To: PostGreSQL
> Subject: [NOVICE] Aliased table names ...oddity?
>
>
> PostgreSQL-7.4.5
>
> I don't know whether this is a 'bug' (it seems like
> designed behaviour)
> - but if you do:
> SELECT markUp.*
> FROM markUp AS mark
> JOIN clientBranch AS clntB
> ON mark.foreignRecNo = clntB.clientRecNo
> AND clntB.recNo = 2
> WHERE mark.serviceCoBranchRecNo = 2
> AND mark.foreignTableName = 'client'
>
>
> So the table has an ALIAS that is ignored in the
> SELECT clause, then the
> WHERE clause is 'ignored' and all rows from the
> table are returned.
> Obviously its a typo in the original SQL - (but one
> that's very difficult to
> pick up unless the data returned is obviously
> outside limits). Running the
> SQL in PSQL, it seems that a FROM clause is
> automatically appended for the
> missing 'markUp' table - so it does seem that this
> is intentional. Is there
> a way to have this 'rejected' as an error - ie
> selecting from a table not
> included in the query?
>
>
> --
>
>
> Regards,
>
> Steve Tucknott
> ReTSol Ltd
>
> DDI 01903 828769
> MOBILE 07736715772
>
>
>
>
>
>
___________________________________________________________
>
> Yahoo! Messenger - NEW crystal clear PC to PC
> calling worldwide with
> voicemail http://uk.messenger.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list
> cleanly
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com