1. Forum
  2. USENET
  3. comp.databases.ingres

  • [Info-ingres] Listagg.....

    From Adrian Williamson@adrian.williamson@rationalcommerce.com to 'Ingres and related product discussion forum' on Thu Feb 11 15:32:00 2021
    From Newsgroup: comp.databases.ingres

    This is a multipart message in MIME format.

    ------=_NextPart_000_0008_01D7008B.0B7CEE70
    Content-Type: text/plain;
    charset="utf-8"
    Content-Transfer-Encoding: quoted-printable

    String Aggregate Functions

    Note: Valid for X100 tables only. =E2=80=93 FECKERS.

    String aggregate functions concatenate a set of string values.

    LISTAGG

    =20

    If I paid a licence fee I=E2=80=99d be upset=E2=80=A6

    =20


    ------=_NextPart_000_0008_01D7008B.0B7CEE70
    Content-Type: text/html;
    charset="utf-8"
    Content-Transfer-Encoding: quoted-printable

    <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta = http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta = name=3DGenerator content=3D"Microsoft Word 15 (filtered =
    medium)"><style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;}
    span.EmailStyle20
    {mso-style-type:personal-compose;
    font-family:"Calibri",sans-serif;
    color:windowtext;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:72.0pt 72.0pt 72.0pt 72.0pt;}
    div.WordSection1
    {page:WordSection1;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext=3D"edit">
    <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DEN-GB link=3Dblue = vlink=3Dpurple><div class=3DWordSection1><div><div><p = class=3DMsoNormal>String Aggregate Functions<o:p></o:p></p><p = class=3DMsoNormal><b>Note:&nbsp;&nbsp;Valid for X100 tables only. =
    =E2=80=93 FECKERS.<o:p></o:p></b></p><p class=3DMsoNormal>String =
    aggregate functions concatenate a set of string values.<o:p></o:p></p><p = class=3DMsoNormal>LISTAGG<o:p></o:p></p><p = class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>If I paid a = licence fee I=E2=80=99d be upset=E2=80=A6<o:p></o:p></p><p = class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></div></div></body></html> ------=_NextPart_000_0008_01D7008B.0B7CEE70--

    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to Adrian Williamson on Fri Feb 12 11:36:27 2021
    From Newsgroup: comp.databases.ingres


    Adrian Williamson <adrian.williamson@rationalcommerce.com> wrote:

    rCo Emma still has not delivered on making OpenROAD the database language (she said this about 20 years ago at a conference)
    Tell you what, you supply Engineering wth the amount of liquor that was being consumed when that
    statement was made, we'll see what we can do!
    I remember that discussion, which is remarkable because even the next day, I didn't remember
    much else from that evening...
    Karl
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Adrian Williamson@adrian.williamson@rationalcommerce.com to 'Karl Schendel' on Fri Feb 12 17:03:33 2021
    From Newsgroup: comp.databases.ingres

    I think that was the afternoon session of the IUG-UK - were you all on the sauce* at lunch?
    Tut Tut.
    I was still in my early thirties back then, donrCOt recall a lot of detail, I may have headed home on the bike after the conference.
    Sauce = Liquor = Sauce
    -----Original Message-----
    From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of Karl Schendel
    Sent: 12 February 2021 16:36
    To: Adrian Williamson <adrian.williamson@rationalcommerce.com>; Ingres and related product discussion forum <info-ingres@lists.planetingres.org>
    Subject: Re: [Info-ingres] Listagg.....
    Adrian Williamson <adrian.williamson@rationalcommerce.com> wrote:

    rCo Emma still has not delivered on making OpenROAD the database language (she said this about 20 years ago at a conference)
    Tell you what, you supply Engineering wth the amount of liquor that was being consumed when that statement was made, we'll see what we can do!
    I remember that discussion, which is remarkable because even the next day, I didn't remember much else from that evening...
    Karl
    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to Adrian Williamson on Fri Feb 12 12:08:54 2021
    From Newsgroup: comp.databases.ingres


    On Feb 12, 2021, at 12:03 PM, Adrian Williamson <adrian.williamson@rationalcommerce.com> wrote:

    I think that was the afternoon session of the IUG-UK - were you all on the sauce* at lunch?

    Tut Tut.
    I'm thinking of one of the big engineering conferences. I guess the enthusiasm carried forward
    a bit. We may have talked ourselves into thinking it was a thing. (It's still not a terrible idea, in
    theory at least.)
    As for "sauce at lunch", we're a global company. "What is lunch?", asked Pilate.

    I was still in my early thirties back then, donrCOt recall a lot of detail, I may have headed home on the bike after the conference.

    Sauce = Liquor = Sauce

    -----Original Message-----
    From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of Karl Schendel
    Sent: 12 February 2021 16:36
    To: Adrian Williamson <adrian.williamson@rationalcommerce.com>; Ingres and related product discussion forum <info-ingres@lists.planetingres.org>
    Subject: Re: [Info-ingres] Listagg.....


    Adrian Williamson <adrian.williamson@rationalcommerce.com> wrote:

    rCo Emma still has not delivered on making OpenROAD the database
    language (she said this about 20 years ago at a conference)

    Tell you what, you supply Engineering wth the amount of liquor that was being consumed when that statement was made, we'll see what we can do!

    I remember that discussion, which is remarkable because even the next day, I didn't remember much else from that evening...

    Karl


    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    --- Synchronet 3.21b-Linux NewsLink 1.2