Re: OOO and postgres

On Fri, 7 Jan 2011, Bernhard Rohrer wrote:

> CREATE TABLE "Bladetypes"
> (
>  "ID" integer NOT NULL,
>  "type" character varying[] NOT NULL,
>  CONSTRAINT "Bladetypes_pkey" PRIMARY KEY ("ID")
> )
>
> ALTER TABLE "Bladetypes" ADD COLUMN "ID" integer;
> ALTER TABLE "Bladetypes" ALTER COLUMN "ID" SET NOT NULL;
>
> ALTER TABLE "Bladetypes" ADD COLUMN "type" character varying[];
> ALTER TABLE "Bladetypes" ALTER COLUMN "type" SET NOT NULL;

   Don't use double quotes in your create table stanza. You can use them on
the table name with alter table and insert into.

   The data type is VARCHAR(), not character varying[].

   Why are you altering the table to be exactly how you defined it?

   Use single quotes to define text strings in your values statements.

   Perhaps you'll find value in reading a book on SQL. Rick van der Lans and
Joe Celko both write outstanding books on the language and its use.

Rich