From: | Leslie Mikesell <les(at)Mcs(dot)Net> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | varchar vs. text |
Date: | 1998-10-24 17:37:42 |
Message-ID: | 199810241737.MAA29834@Jupiter.mcs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Is there any way to apply the text functions to a varchar field or
convert from varchar to text? I set up a database with varchar
fields with unspecified sizes because at the time the odbc driver
didn't like to use text as a unique key. Now pg_dump sets the
size as (-5) which won't reload unless I take it out, and I can't
use many of the text-style operators. Using field::text gives:
'ERROR: function text(varchar) does not exist'. Is there any
reason to use varchar now that the ODBC driver works with text,
and is there any way to convert short of pg_dump'ing and editing
the structure?
Les Mikesell
les(at)mcs(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-10-25 09:49:03 | Re: [SQL] Reading and writing at the same time |
Previous Message | G. Anthony Reina | 1998-10-23 18:57:36 | Reading and writing at the same time |