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>
  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 07:14  Tom Lane <tgl@sss.pgh.pa.us>
  parent: David J. R. Brook <brookd@udmercy.edu>
  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