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.)

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

tony@mountifield.org (Tony Mountifield) writes:

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.)

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

In article <name-20200317175735@ram.dialup.fu-berlin.de>,
Stefan Ram <ram@zedat.fu-berlin.de> wrote:

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
--
Tony Mountifield
Work: tony@softins.co.uk - http://www.softins.co.uk
Play: tony@mountifield.org - http://tony.mountifield.org

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 17/03/2020 19.54, Stefan Ram wrote:

tony@mountifield.org (Tony Mountifield) writes:

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.

--

//Aho

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

According to DFS <nospam@dfs.com>:

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.

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 ess@ansi.org. I just did.

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

--
Regards,
John Levine, johnl@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 3/18/2020 2:52 AM, J.O. Aho wrote:

On 17/03/2020 19.54, Stefan Ram wrote:

tony@mountifield.org (Tony Mountifield) writes:

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.

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 ess@ansi.org. I just did.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 9/8/2021 5:01 PM, John Levine wrote:

According to DFS <nospam@dfs.com>:

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.

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 ess@ansi.org. I just did.

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.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)