On Tue, 8 Jan 2002, Thomas Lockhart wrote:
> > > > Does this have the multiple "WITH xxx" clauses which were discussed
> > > > earlier? That is a nonstarter for syntax. There are other places in the
> > > > grammar having "with clauses" and multiple arguments or subclauses, and
> > > > having the shift/reduce issues resolved...
> ...
> > CREATE DATABASE <name> WITH LOCATION = <name> WITH OWNER = <name>
>
> It was this syntax I was wondering about. Multiple "WITH"s should not be
> necessary. Are they actually required in the patch?
Argh. My bad. The syntax is what you had in mind:
CREATE DATABASE <name> [WITH [LOCATION <name>] [OWNER <name>] ...]
Gavin