Re: [SQL] Problem with array of char

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: Stephane MONEGER <moneger(at)NCTech(dot)FR>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Problem with array of char
Date: 1998-06-07 08:26:28
Message-ID: l03110703b19ffcf97ced@[147.233.159.109]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

At 11:07 +0300 on 4/6/98, Stephane MONEGER wrote:

> Do you have an idea? A solution? I have very large tables and char[][]
> is the only way I found to save values of 1 byte (as thin int are not
> supported by PostgreSQL).

I'm not sure if it's any help, but PostgreSQL has a built-in type called
"bytea", which is a variable-length array of bytes. Maybe you should play
around with it. I'm not sure how values are inserted to it - it seems to
behave very much like the text type.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christian Pomar Berry 1998-06-07 11:23:49 suscribe
Previous Message Herouth Maoz 1998-06-07 08:13:29 Re: [SQL] problems with CAST :-{