Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL Naming Rules - another question

PostgreSQL Naming Rules - another question

From
Szymon Guz
Date:
Hi,
according to this part of documentation:


if I select some names from database and sort them... which collation is used?

regards
Szymon


Re: PostgreSQL Naming Rules - another question

From
Sim Zacks
Date:
body p { margin-bottom: 0cm; margin-top: 0pt; }

  <body style="direction: ltr;"
    bidimailui-detected-decoding-type="UTF-8" bgcolor="#ffffff"
    text="#000000">
    On 10/29/2011 12:53 PM, Szymon Guz wrote:
    <blockquote
cite="mid:CAFjNrYvp2Jtt7-CCqAc4un4owpM0hVU22_gxsnRi8H1yaHuOPw@mail.gmail.com"
      type="cite">Hi,
      according to this part of documentation:


      <span class="Apple-style-span" style="color: rgb(68, 68, 68);
          font-family: arial,sans-serif; font-size: 13px;
          background-color: rgb(255, 255, 255);"><a
            moz-do-not-send="true"
href="http://www.postgresql.org/docs/9.1/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS"
            target="_blank" style="text-shadow: 0px 0px 1px rgba(0, 0,
            0, 0.008); color: rgb(34, 34,
34);">http://www.postgresql.org/docs/9.1/interactive/sql-syntax-lexical.html#SQL-<br
              style="text-shadow: 0px 0px 1px rgba(0, 0, 0, 0.008);">
            SYNTAX-IDENTIFIERS


      if I select some names from database and sort them... which
        collation is used?


      regards
      Szymon





    Each database has collation defined when it is created.