Jaime Casanova <jcasa...@systemguards.com.ec> writes: > On Fri, Feb 26, 2010 at 7:12 PM, Michael Glaesemann <g...@seespotcode.net> > wrote: >> In any event, I couldn't get your example to work on Postgres 8.4 regardless >> due to the varchar2 type. Which version of Postgres are you using? >> >> test=# CREATE TABLE footable(id int4, name varchar2(10)); >> ERROR: Â type "varchar2" does not exist
> it;s probably postgres plus (the enterprisedb fork), Yeah, particularly given the OP's address ;-). The example goes through fine in standard Postgres if you use varchar, or indeed any other datatype. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers