Re: Created a PostgreSQL test, what do you think? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Created a PostgreSQL test, what do you think?
Date
Msg-id CAHyXU0ydN1R+Ly0zabPVTOD-Cy2zByD-qC6Wo0E24sx=BaHHfA@mail.gmail.com
Whole thread Raw
In response to Created a PostgreSQL test, what do you think?  (Jsmarterer <justin@smarterer.com>)
List pgsql-general
On Wed, May 1, 2013 at 9:16 AM, Jsmarterer <justin@smarterer.com> wrote:
> Hey gang,
>
> We created a PostgreSQL test for database admins to test their knowledge and
> prove their skills to employers and members of the community. What do you
> think? By taking the test and flagging any wonky questions, you'll be
> helping make the test better for future PostgreSQL users.
>
> Check it out here <http://smarterer.com/tests/postgresql?c=forum-postgresql>
>
> Let me know if you have any questions and post your scores below!


more nits:
*) you may issue ALTER TABLE during vacuum.  (it blocks, but you can
still issue).
*) lower() functional index is not case insensitive indexing and use
of lower function is at least partially required.

melrin


pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Simple SQL INSERT to avoid duplication failed: why?
Next
From: Ralph Graulich
Date:
Subject: tstzrange with ... 'infinity'] + upper_inf() using 9.2.4