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: [SQL] Bit string help, please [EMAIL PROTECTED] wrote: > 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 much. Ah, sorry - that was an 8.3-only cast. I think your only real option will be to build your query as a string and use EXECUTE to get the bit-varying you want in your function. -- Richard Huxton Archonet Ltd -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-sql
