pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
2+ messages / 2 participants
[nested] [flat]
* (no subject)
@ 2001-01-27 00:03 David J. R. Brook <brookd@udmercy.edu>
2001-01-27 07:14 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: David J. R. Brook @ 2001-01-27 00:03 UTC (permalink / raw)
To: pgsql-sql
I'm trying to use the 'bit' and 'varbit' datatypes in a
table. The demo file 'varbit.demo.sql' runs fine but
when I
try to INSERT data into the table I get a message:
ERROR: zpbit_in: bit string of size 8 cannot be
written into
bits(1)
I can add data to the table through the console a la
demo
file though. I can also write one binary digit (i.e.
'B1')
using INSERT but I cannot write longer bit strings -
neither
can I find a way to make the type of the column to be
a
longer bit string. Any suggestions?
(I get the same problem with the varbit data type)
David Brook
Asst. Professor, Department of Chemistry and
Biochemistry
University of Detroit Mercy
ph: (313) 993-2495
fax: (313) 993-1144David Brook
Asst. Professor, Department of Chemistry and Biochemistry
University of Detroit Mercy
ph: (313) 993-2495
fax: (313) 993-1144
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re:
2001-01-27 00:03 (no subject) David J. R. Brook <brookd@udmercy.edu>
@ 2001-01-27 07:14 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2001-01-27 07:14 UTC (permalink / raw)
To: David J. R. Brook <brookd@udmercy.edu>; +Cc: pgsql-sql
"David J. R. Brook" <brookd@udmercy.edu> writes:
> I'm trying to use the 'bit' and 'varbit' datatypes in a table.
What version are you running? IIRC, there are types calling themselves
bit and varbit in 7.0, but they're only stubs; the first real support
for bitstrings is in 7.1.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-27 07:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-27 00:03 David J. R. Brook <brookd@udmercy.edu>
2001-01-27 07:14 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
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