pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with array of char
2+ messages / 2 participants
[nested] [flat]
* Problem with array of char
@ 1998-06-04 08:07 Stephane MONEGER <moneger@NCTech.FR>
1998-06-07 08:26 ` Re: [SQL] Problem with array of char Herouth Maoz <herouth@oumail.openu.ac.il>
0 siblings, 1 reply; 2+ messages in thread
From: Stephane MONEGER @ 1998-06-04 08:07 UTC (permalink / raw)
To: pgsql-sql
Hi!
I have a serious problem with PostgreSQL 6.3 concerning array of char...
I can create table with array of char2 for exemple, but not array of
char.
create table tab1(a char2[][]); -> OK
create table tab2(a int2[][]); -> OK
create table tab3(a char[][]); -> error...
I can't find it as a known bug and this functionality was possible with
previous version of Postgresql.
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).
Thanks!
Stephane
--
________________________________________________________________________
Network Computing Technologies
Stéphane MONEGER
Information System Designer
Marimba Certified Consultant
NCTech Phone : +33 4 78 61 46 29
8, rue Hermann Frenkel Fax : +33 4 78 61 46 99
69007 LYON Cedex FRANCE Email : smoneger@nctech.fr
________________________________________________________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] Problem with array of char
1998-06-04 08:07 Problem with array of char Stephane MONEGER <moneger@NCTech.FR>
@ 1998-06-07 08:26 ` Herouth Maoz <herouth@oumail.openu.ac.il>
0 siblings, 0 replies; 2+ messages in thread
From: Herouth Maoz @ 1998-06-07 08:26 UTC (permalink / raw)
To: Stephane MONEGER <moneger@NCTech.FR>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-06-07 08:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-04 08:07 Problem with array of char Stephane MONEGER <moneger@NCTech.FR>
1998-06-07 08:26 ` Herouth Maoz <herouth@oumail.openu.ac.il>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox