Re: Hi!, help with this new type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Cruz <davidcrmail(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Hi!, help with this new type
Date: 2004-06-01 06:14:07
Message-ID: 28393.1086070447@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

David Cruz <davidcrmail(at)yahoo(dot)com> writes:
> pruebas1=> create type newtype as (number integer, str
> char(20));
> ERROR: parser: parse error at or near "as"

> And I get that error, could somebody help me?...I'm
> using PostgreSQL 7.4

I'd bet not. That example works fine in 7.4 for me. The
syntax error is exactly what I get in 7.2 though...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Derrick Betts 2004-06-01 06:18:03 Re: Dynamic Array into pl/pgSQL function
Previous Message David Cruz 2004-06-01 05:20:14 Hi!, help with this new type