On Fri, 21 May 2010 10:43:02 +0200, Lennart Jonsson wrote:


My query ran with the "level" column, with no problems, pgsql 8.4.3.



--
http://mgogala.byethost5.com

On 2010-05-21 14:15, Mladen Gogala wrote:
A dbms may or may not accept reserved words, but in general it is a bad
idea to (ab)use them. Even though DB2 V9.5 gladly accepts:

db2 "create table from ( where char(5) not null primary key )"
db2 "insert into from (where) values ('where')"
db2 "select where from from where where = 'where'"

WHERE
-----
where

I would not use those names.


/Lennart

On Fri, 21 May 2010 16:58:23 +0200, Lennart Jonsson wrote:


That's a reasonable suggestion. I used "LEVEL" to emulate Oracle's
"CONNECT BY" behavior which produces the level column. Well, it'll have
be "LEV", from now on.



--
http://mgogala.byethost5.com

On 2010-05-21 23:02, Mladen Gogala wrote:
[...]
Don't get me wrong. There might be perfectly good reasons to violate a
principle, guideline, rule of thumb, etc. But one should be aware that
it was done and why it was done. In some situations it might not even be
possible to conform to all requirements. By documenting these exceptions
it will be easier to fix them if necessary (in another dbms, a later
version of the same dbms, etc).

/Lennart