twice the same column name

[Stefan Ram]

Sorry, can't find a better newsgroup!

Does ISO SQL forbid Views with the same column name
twice anywhere? As in

CREATE VIEW V AS SELECT C,C FROM T;

. If so, where does ISQ SQL forbid this? TIA!

(MySQL does clearly forbid this.)

[Luuk]

Post by Stefan Ram
Sorry, can't find a better newsgroup!
Does ISO SQL forbid Views with the same column name
twice anywhere? As in
CREATE VIEW V AS SELECT C,C FROM T;
. If so, where does ISQ SQL forbid this? TIA!
(MySQL does clearly forbid this.)

https://bugs.mysql.com/bug.php?id=15443
Bug description: Views: can't create view, error 'Duplicate column'
Bug Status: Not a bug

[Tony Mountifield]

Post by Stefan Ram
Sorry, can't find a better newsgroup!
Does ISO SQL forbid Views with the same column name
twice anywhere? As in
CREATE VIEW V AS SELECT C,C FROM T;
. If so, where does ISQ SQL forbid this? TIA!
(MySQL does clearly forbid this.)

I certainly doesn't make sense: would V.C refer to the first or the second instance?

You could do:

CREATE VIEW V AS SELECT C, C AS C2 FROM T;

And then access V.C and V.C2.

I suppose the question is: why to you need to do this?

Cheers
Tony

[Stefan Ram]

Post by Tony Mountifield
I suppose the question is: why to you need to do this?

Thanks for answering, but I don't need to /do/ anything.
I'd just like to /know/ the answers to my two questions.
Why? For teaching purposes. (But knowing why I need the
answers will not help answering the questions I'm afraid.)

[J.O. Aho]

Post by Stefan Ram

Post by Tony Mountifield
I suppose the question is: why to you need to do this?

Thanks for answering, but I don't need to /do/ anything.
I'd just like to /know/ the answers to my two questions.
Why? For teaching purposes. (But knowing why I need the
answers will not help answering the questions I'm afraid.)

I would guess it may be mentioned in an ANSI documentation, maybe in one
of those linked on this page:
https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd

Just have your creditcard ready, as they seems to want 200+ USD for one
document.

[DFS]

Post by J.O. Aho

Post by Tony Mountifield
I suppose the question is: why to you need to do this?

   Thanks for answering, but I don't need to /do/ anything.
   I'd just like to /know/ the answers to my two questions.
   Why? For teaching purposes. (But knowing why I need the
   answers will not help answering the questions I'm afraid.)

I would guess it may be mentioned in an ANSI documentation, maybe in one
https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd
Just have your creditcard ready, as they seems to want 200+ USD for one
document.

If you're a member. $250 if not.

I just chatted with someone at ansi.org and said your pdf prices were
too high and she said 'sorry you feel that way' and then asked 'Is there
anything else we may assist you with today?'.

You can complain at ***@ansi.org. I just did.

[John Levine]

Post by DFS

Post by J.O. Aho
I would guess it may be mentioned in an ANSI documentation, maybe in one
https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd
Just have your creditcard ready, as they seems to want 200+ USD for one
document.

If you're a member. $250 if not.
I just chatted with someone at ansi.org and said your pdf prices were
too high and she said 'sorry you feel that way' and then asked 'Is there
anything else we may assist you with today?'.

ANSI funds itself by selling copies of standards so I wouldn't waste my time.

[DFS]

Post by John Levine

Post by DFS

Post by J.O. Aho
I would guess it may be mentioned in an ANSI documentation, maybe in one
https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd
Just have your creditcard ready, as they seems to want 200+ USD for one
document.

If you're a member. $250 if not.
I just chatted with someone at ansi.org and said your pdf prices were
too high and she said 'sorry you feel that way' and then asked 'Is there
anything else we may assist you with today?'.

ANSI funds itself by selling copies of standards so I wouldn't waste my time.

What does ANSI.org do to justify such exorbitant prices? Nothing as far
as I can tell.

Most if not all the standards writers are employed in occupations where
they develop the expertise to write the standards. So they're already paid.

The 14-part SQL document would cost a non-member ~$3500. It's ridiculous.

[John Levine]

Post by DFS

Post by John Levine
ANSI funds itself by selling copies of standards so I wouldn't waste my time.

What does ANSI.org do to justify such exorbitant prices? Nothing as far
as I can tell.
Most if not all the standards writers are employed in occupations where
they develop the expertise to write the standards. So they're already paid.

There is a lot of clerical and editorial work involved. BTDT.

The IETF gives away its standards for free, but only because the Internet
Society makes enough from .ORG to give it a $6 million/year subsidy.