* SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes

* SELECT DISTINCT ON col1 col1 col2 FROM tab1 is broken [distinct]

* -When using aggregates + GROUP BY, no rows in should yield no rows out(Tom)

* Allow HAVING to use comparisons that have no aggregates, for portability

*-Allow HAVING to use comparisons that have no aggregates(Tom)

VIEWS

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.8 1999/07/22 15:09:08 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.9 1999/10/07 16:40:36 momjian Exp $

Postgres documentation

-->

Create a user with a password:

<programlisting>

CREATE USER davide WITH PASSWORD jw8s0F4

CREATE USER davide WITH PASSWORD"jw8s0F4"

</programlisting>

</para>

valid:

<programlisting>

CREATE USER miriam WITH PASSWORD jw8s0F4 VALID UNTIL 'Jan 1 2002'

CREATE USER miriam WITH PASSWORD"jw8s0F4" VALID UNTIL 'Jan 1 2002'

</programlisting>

</para>

<para>

Create an account where the user can create databases:

<programlisting>

CREATE USER manuel WITH PASSWORD jw8s0F4 CREATEDB

CREATE USER manuel WITH PASSWORD"jw8s0F4" CREATEDB

</programlisting>

</para>

</refsect1>