Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.mysql > #7432 > unrolled thread

Re: twice the same column name

Back to article view | Back to comp.databases.mysql

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: twice the same column name tony@mountifield.org (Tony Mountifield) - 2020-03-17 18:30 +0000
    Re: twice the same column name "J.O. Aho" <user@example.net> - 2020-03-18 07:52 +0100
      Re: twice the same column name DFS <nospam@dfs.com> - 2021-09-08 16:44 -0400
        Re: twice the same column name John Levine <johnl@taugh.com> - 2021-09-08 21:01 +0000
          Re: twice the same column name DFS <nospam@dfs.com> - 2021-09-09 10:36 -0400
            Re: standards, twice the same column name John Levine <johnl@taugh.com> - 2021-09-10 01:12 +0000

#7432 — Re: twice the same column name

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

[toc] | [next] | [standalone]

#7434

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

[toc] | [prev] | [next] | [standalone]

#7613

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.

[toc] | [prev] | [next] | [standalone]

#7614

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

[toc] | [prev] | [next] | [standalone]

#7615

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.

[toc] | [prev] | [next] | [standalone]

#7616 — Re: standards, twice the same column name

According to DFS  <nospam@dfs.com>:
>> 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.

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.mysql

csiph-web