Re: Aliased table names ...oddity?

Ignore this.
Just seen the post re MySQL/PostgreSQL 'gotchas' - and this is one of
them - with the answer that I was after.

On Thu, 2005-06-30 at 07:54, Steve Tucknott wrote:
> 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@postgresql.org so that your
>        message can get through to the mailing list cleanly
--


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