Thanks for the help again, Richard. I will look into upgrading to 8.3
as I think that will be the best solution.
Ed Tyrrill
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2008 10:36 AM
To: Tyrrill, Ed
Cc: pgsql-sql@postgresql.org
Subject: Re:
I tried this real quick at the psql command prompt, and unfortunately it
doesn't work:
mydb=# select ('1' || repeat('0',7))::bit varying;
ERROR: cannot cast type text to bit varying
I appreciate the try though. Any other ideas? I am using PostgreSQL
8.2.3.1. I don't know if that matters too m
Hey PostgreSQL Gurus,
I am experimenting with PostgreSQL bit strings to see if they might help
with some performance issues I am having. I added a "bit varying"
column to one of my tables. I have a PL/pgSQL function with an insert
statement into this table. For the bit varying column I would li
Hey All,
I have a query I'm trying to speed up, and I was hoping someone could
help me. I have a three tables a and b hold data, and c just references
between a and b:
create table a (
a_id int,
x int
);
create table b (
b_id int,
x int
);
create table c (
a_id int,
b_id int
